The idea here is to expand the formula editor (Specifically CASE WHEN Statements) to allow the creation of dimensions or "buckets" based on filtered data. This is useful on the dashboard level as we may want to recategorize our data dynamically after filtering the dashboard.
Lets say I have a pretend table holding daily customer transactions. In my report I'd want to see each customer's average spending for an arbitrary time frame. I'd also like to categorize that player BASED off that average spending. Which could change based on any filters I use.
IE)
CASE
WHEN [Avg Money Spent] > 999 then '1000+'
WHEN [Avg Money Spent] > 699 then '700 to 999'
WHEN [Avg Money Spent] > 399 then '400 to 699'
...
WHEN [Avg Money Spent] >= 0 then '0 to 99'
ELSE NULL
END
I would then use this calculated dimension in visualizations like pie charts, etc.
I'm not sure if this is possible, but being able to use this dimension as a filter would be very useful as well.
IE) Show me all the customer who fall under '400 to 699' range for any given period.
