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.
Thanks in advance!!