I am trying to create a pie chart that will group companies by number of subscriptions, and combine them where the total value is < 9000.
For example, the key would be:
Number of Subscriptions:
8
7
6
5
4 or less subscriptions
Say 200 companies have 4 or less subscriptions, the total value of their combined subscriptions should be grouped together as one value on the pie chart and shown as one colour. The rest (5 to 😎 should have their values in total too, so the total value of all companies with 5 subscriptions (as say blue in the pie chart), the total value of all companies with 6 as red etc, but represented as different sections of the pie...
I am finding it difficult to figure out what my dimensions should be and expressions. This is the inline test data:
I have tried using sum(value) as the expression and this as the dimension:
=aggr(if(rank(Product_Name) <= 4, Value), Value)
This however ignores anywhere with > 4 subscriptions, but also does not combine all values where they subscribe to <= 4. I was expecting to see part of the pie chart say (blue) 69,975 (as that is the value of all accounts with <= 4 subscriptions), then another part which says 8,400 as say red, as one customer has 7 subscriptions and would not fall within the combined group...
