i want to create a pie chart with costumized colors.
I know that you can use the pick/match function for that. However, the chart shows a drilldown dimension. How can I costumize the colors of the second dimension too?
A table for better explanation:
Object
Dimension1
Dimension2
1
a
aa
2
b
bb
Lets say a should be red, b blue, aa yellow and bb green.
I think you can use conditional color property in color tab.Expression would be if(getcurrnetselection('Drilldown dimension name')='a',Red) hope this might help