Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi the community,
I'm trying to build a block chart made of 40+ blocks. The color of each block will depend wether it's 'yes' (green), 'no' (red)
I wrote the formula (see below) under color tab/dataapperance/calculatedcolor but it doesnt work + it only applies to one dimension and not the 39 others.
if (Expression) = 'yes', RGB (255, 0, 0), RGB (0, 255, 0))
unit A, yes
unit B, yes
unit C, no
unit D, yes
unit E, no
etc
An other pbm I'm facing: the condition is a variable and might change from yes to no every other month.
Does anyone of you know how to proceed ?
Thank you
In your Expression, click the + sign next to the expression. Enter your color expression as the "Background Color" expression.
-Rob
In your Expression, click the + sign next to the expression. Enter your color expression as the "Background Color" expression.
-Rob
Hi
you change the colors in the expression tab
As per your Requirement in the expression
if (Expression) = 'yes', RGB (255, 0, 0), RGB (0, 255, 0))