I am looking at different ways to present a block chart and I'm experimenting with constant colours.
So I have 2 dimensions - L1 Rate Band*,
L2 Description
then an expression sum(clients)
*I am using a class and aggr function to calc rate band in other words it is dynamic and output for a row might be "£30<=Rate<£35"
=class(aggr(avg(Price),Description),50,'Rate')
I would like the L1's in the same band to be the same colour. I would like to loop round the 18 colour settings for the chart using the color(x) function.
Anyone got a slick way of doing this? Id also like to exclude having to use L1 and only L2 with the colour being the L1 but block charts do not have a sort option?!
