Custom bucketing for a measure field
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 |
What is the recommended approach in Pyramid for creating these custom non-overlapping integer 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?