you could write your own logic to create non standard bins something like that
IF Transactions<500 THEN "TYPE A"
ELSEIF Transactions<750 THEN "TYPE B"
ELSEIF Transactions<3250 THEN "TYPE C"
ELSEIF Transactions<12500 THEN "TYPE D"
ELSEIF Transactions<16000 THEN "TYPE E"
ELSE "TYPE W"
1 of 1 people found this helpful
Christian's solution offers a quick fix and that might work well for you (although, I think it should probably be SUM(Transactions) in each of the logic steps...
If you want to do it by percentile then this is quite possible using the formula
index() / size()
Add that to colour and make sure it is set to compute using Country, sorted by sum of Transactions (see screenshot, mine is sorted by Sum of Sales)
Many thanks Robin,
I will try your solution. I think this will be answer I need.
Thanks for your respond. The problem with the solution your propose is that it is not dynamic. So if I want to allow users to filter by department, subsidiary, or several months.... this will not work.
Many thanks Cristian,
I will try this to create the percentile for the map.