Hello,
I have created a table calculation that will calculative the cumulative % of total for a number of different buckets (Less than 2, 3 to 10, More than 10 this example).
I want to display just the cumulative % of total just for the 'Less than 2' bucket as a line chart (without the other 3 buckets). The problem is (obviously), when I filter out the other 2 buckets, the cumulative % just goes to 100%.
I've been playing around with LOD calculations, but given these apply after a context filter, I'm not sure they are the answer. Can someone please help?
OK, I see now. You're having an order of operations problem. Dimension filters compute before table calcs. So we need to find a way to compute the filter after the table calc. I go into this problem in detail on # 5 of the following blog: https://www.flerlagetwins.com/2020/09/order-of-operations.html
In your case, create a calculated field like this:
Bucket TC
// Force Bucket to be a table calc so that...
// ...the filter compuetes after the table TC on the view.
LOOKUP(MAX([Bucket]), 0)
Then use that as a filter. Because this will be a table calc filter, it will compute after the table calculation on the view.
See attached.
