Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All I am trying to write an expression for colours in a Bubble Chart. The expression works for one colour but how do I add an else if to add the other colours.
if
(count ([Asset ID]=0),LightBlue())>=5),Lightred())
if (count ([Serial #])=0, white(), if (count ([Serial #])<=100, red(), if (count ([Serial #])>101, Blue())))
Sorted
Sorry expression is
if
(count ([Asset ID]=0),LightBlue())>=5),Lightred())
if (count ([Serial #])=0, white(), if (count ([Serial #])<=100, red(), if (count ([Serial #])>101, Blue())))
Sorted