Custom bucketing for a measure with integer ranges
I have a measure called Frequency of Unusual Activity, which represents the number of times a user has been flagged.
I am currently using Bin by Value in Pyramid to create frequency buckets. Pyramid is generating ranges like:
0 - 12
12 - 24
24 - 36
36 - 48I want the buckets to be displayed as:
0 - 12
13 - 24
25 - 36
37 - 48I also tried creating a calculated measure in Formulate, but since the source is already an aggregated measure, I am not able to use the calculated result as a categorical bucket on Rows in the required way.
My expected output is something like:
Frequency Range Unique Users
| 0–12 | 250 |
| 13–24 | 180 |
| 25–36 | 95 |
| 37–48 | 60 |
The bucketing also needs to remain dynamic when dashboard filters such as Date, Department, Team, and Location are applied.
What is the recommended approach in Pyramid for creating these custom buckets from an aggregated measure? Can this be achieved through Bin by Value configuration, or should it be implemented using a Custom List / Filter-based calculation / calculated set?