topic Re: Color By Expression for one dimension in App Development

Color By Expression for one dimension

acrodrigues03 — Fri, 23 Feb 2018 14:44:53 GMT

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

acrodrigues03 — Fri, 23 Feb 2018 14:50:54 GMT

I need to do this with set analysis

Anonymous — Fri, 23 Feb 2018 14:51:17 GMT

You could create a Master Item using your Channel dimension and assigned colours to values :

acrodrigues03 — Fri, 23 Feb 2018 16:22:44 GMT

Hi Bill!

Thank you for your fast response! Unfortunately I need to define them outside of the master items with set analysis

Anonymous — Fri, 23 Feb 2018 16:41:12 GMT

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.

lcontezini — Fri, 23 Feb 2018 16:42:20 GMT

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()))