How to create hexcolors with expression in pie chart (dynamic number of values)
Hi Community,
I would like to create a pie chart, filled with my own colors (for example: #AAAAAA,#BBBBBB,#CCCCCC).
My dimension can have 1 to 10 possible values, in my example: 3:
Most common value must have #AAAAAA, 2nd: #BBBBBB, 3rd: #CCCCCC
How to realise this? I tried options like firstsortedvalue in combination with a if condition and with use of a variable, but I hope anybody can help me.