Calculated Field: Opening Age

To build the day's open calculated field, we'll go to the admin tab and then we'll search for calculated fields.

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.

Next we want a filter bucket field and we'll click create create.

Next let's add a bucket and we'll title this 0 to 30 days.

Let's add in our filter in this case.

We want the open duration in days and we'll select is less than or equal to 30.

Let's go ahead and add a new bucket.

This one will be 31 to 60 days.

Next we'll choose is between and we'll enter in 31 and 60.

We'll add another bucket in this case 61 to 90.

Now we'll update our time frame from 31 to 61 and from 60 all the way to 90.

Our last bucket.

We'll do 91 plus days.

We'll switch our filter to is greater than or equal to 91.

That's it.

We now have a days open calculated field.

Let's build a quick report.

We'll add our subject to openings and we'll go ahead and group these by our days open calculated field.

We can now see our grouped buckets like 0 to 30 days, 31 to 60 and 61 to 90.

This can be really helpful if you have a large number of openings.