Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have calculated dimension, I want to show colour based on condition,
if Calculated value > than 0.80, colour should be green()
if Calculated value < than 0.80, colour should be red()
Also, How to give range and limits using segments?
Hi Ram,
so, following the images I sent before you would have sth like:
First Dimention
=1 (or any text you would like)
Second Dimentions
=Valuelist(1, 2) (or any two names you would like
Measure:
if( valuelist(1,2)=1
,[Your Expression that returns a number between 0 and 1]
, 1 - [Your Expression that returns a number between 0 and 1]
)
Color Expression:
if( (valuelist(1,2)=1) and ([Your Expression that returns a number between 0 and 1]<0.8)
, Red()
,if( valuelist(1,2)=1
,Green()
,LightGray()
)
)
Thank you Once Again, Caio. It's working now.