Hi! We have a requirement to show open HR cases age within these buckets:
< 3 business days
3 - 5 business days
5 - 10 business days
15 - 30 business days
> 30 business days
I tried this with the report designer and it seems the standard/OOB when I group by created date is only 7, 30, and 120 days. Anyone who had this similar requirement and what was the resolution? Appreciate your help team! Thanks!
To create a 'range' in the report you could do something like this with the conditions, although it is a little laborious. Ideally, you would be using Performance Analytics to track this data so you can get this information easily.
Try changing your conditions in line with the example below:
This would give you things that were created between 15 and 30 days ago. You would need to create one of these conditions for each of the criteria you mentioned, which will look something like this.
You may have some trouble grouping the data in the labeled bar charts that you showed in your original screenshot, but these are the conditions you need to apply to get the ranges that you need.
To create a 'range' in the report you could do something like this with the conditions, although it is a little laborious. Ideally, you would be using Performance Analytics to track this data so you can get this information easily.
Try changing your conditions in line with the example below:
This would give you things that were created between 15 and 30 days ago. You would need to create one of these conditions for each of the criteria you mentioned, which will look something like this.
You may have some trouble grouping the data in the labeled bar charts that you showed in your original screenshot, but these are the conditions you need to apply to get the ranges that you need.
