Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to incorporate a cyclic group for my dimension in the chart below. However, when I cycle through the group, which is defined based on different time frames such as on an annual, monthly, and quarterly basis, each time frame cumulates my expressions.
Example Chart: Unfiltered
Example Chart: Filtered
How can I make it so when I drill down, quarterly values displayed are not cumulative?
What expression are you using?
I would something like this:
Avg(Aggr(YourExpression, Monthly))
But to offer more help, need to know more details.
Best,
Sunny
What expression are you using?
I would something like this:
Avg(Aggr(YourExpression, Monthly))
But to offer more help, need to know more details.
Best,
Sunny
Opted for AVG() instead of SUM(). Thanks sunindia, again!
No problem
I am glad we were able to figure it out.
Best,
Sunny