Jace's workspace
01:33
Calculated Field: Opening Age
Jace Talamantes
Oct 17, 2025
8 views
Comment
Copy link
Transcript
Comments
Settings
Transcript
Copy
00:00
To build the day's open calculated field, we'll go to the admin tab and then we'll search for calculated fields.
00:06
Let's go ahead and create a new one and our object type in this case will be openings and we'll title this days open.
00:13
Next we want a filter bucket field and we'll click create create.
00:17
Next let's add a bucket and we'll title this 0 to 30 days.
00:25
Let's add in our filter in this case.
00:27
We want the open duration in days and we'll select is less than or equal to 30.
00:33
Let's go ahead and add a new bucket.
00:35
This one will be 31 to 60 days.
00:41
Next we'll choose is between and we'll enter in 31 and 60.
00:46
We'll add another bucket in this case 61 to 90.
00:51
Now we'll update our time frame from 31 to 61 and from 60 all the way to 90.
00:57
Our last bucket.
00:58
We'll do 91 plus days.
01:01
We'll switch our filter to is greater than or equal to 91.
01:05
That's it.
01:06
We now have a days open calculated field.
01:09
Let's build a quick report.
01:15
We'll add our subject to openings and we'll go ahead and group these by our days open calculated field.
01:22
We can now see our grouped buckets like 0 to 30 days, 31 to 60 and 61 to 90.
01:30
This can be really helpful if you have a large number of openings.
Comments
00:00
No comments yet
Calculated Field: Opening Age — Tella