I was looking into a ticket with a colleague and found a use case where a customer was using a Metric to track if an employee is ramped or ramping.
The configuration is a simple metric, dimensioned by Employee and Month with a datatype of a Dimension (Used to flag whether an employee is ramping or ramped)
This works perfectly when bucketing sales into either being made during the Ramping/Ramped phase to help with forecasting.
However, if you want to account for quarters you end up with values in Ramping and Ramped.
To account for this I assigned a value to each dimension
Then I aggregated the values in a Metric dimensioned by Quarter instead of Month
I was then able to create a similar metric to before, but this time, if any month in the quarter contained ‘Ramping’ the whole month, would display as ‘Ramping’