Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I have a bar chart, where the dimensions are created with the following aggr function
=aggr(if([Comment age]>30,'over 30 dd',if([Comment age]<=30 and [Comment age]>20,'from 21 to 30 dd',if([Comment age]>10 and [Comment age]<=20,'from 11 to 20 dd',if([Comment age]>5 and [Comment age]<=10,'from 6 to 10 dd',if([Comment age]<=5,'less than 5 dd'))))),[Comment age])
basically, it clusters "comments" (my item) aging by a set of rules.
Now, I want to color each bar chart according to its cluster, e.g. I need 'less than 5 dd' bar to be dark green, 'from 6 to 10 dd' bar to be light green, and so on.
Do I need to custom color by dimension or by expression? If it's the first case, I don't have a dimension to relate, if it's the second, I simply don't know which formula is best to use.
could you kindly suggest me a way to proceed?
thanks in advance,
Alia
it works perfectly, thank you very much for your patience 🙂