Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All!
I have a pie chart only with one dimension that is:
=IF([Channel]='A','1',
IF([Channel]='B' or
[Channel]= 'C' or
[Channel]='D' ,
'2',
IF([Channel]='E' or
[Channel]= 'F' or
[Channel]='G' ,
'3',)))
So my pie chart has 3 sections: 1,2 and 3.
I want to define the colors for each section. How can I do that?
Thank you in advance!
Carina
I need to do this with set analysis
You could create a Master Item using your Channel dimension and assigned colours to values :
Hi Bill!
Thank you for your fast response! Unfortunately I need to define them outside of the master items with set analysis
In the properties panel go to:
Use an expression something like
if ( equipment_owner = 'Leased' , green() , yellow() )
You can use whatever expression suits your needs.
Create the dimension in your script, then you colour your graph by expression, using the new dimension, like:
if(new_dimension=1,blue(),
if(new_dimension=2,green(),red()))