Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello friends,
i have to display the trend chart(bar chart for 12 months data) in 3 different colors (red, green, amber) depends on the threshold value(RAG values).
Dimension : Month
Expression:
=Sum ([Abs (FTE)])/Sum ([Avail (FTE)])
and the value of backgroud Color property of this expression is
=if( Sum ([Abs (FTE)])/Sum ([Avail (FTE)]) <3.79 ,RGB(69,234,21), if (Sum ([Abs (FTE)])/Sum ([Avail (FTE)])<4, rgb(255,128,0), RGB(255,0,0)))
But iam getting one color for the all the months, Please check the attachment for the reference.
Please help me.
Regards
Siva
in the properties, color tab, mark the multicolor box.
HI
Its showing in precentage value.. so related to that value, given in background color.
Check the 3.79 values , its either the percentage value or actual value..
May be its helps..Can you post a sample file?
Mayil,
Thanks for your reply. Its working now.
Regards
Siva Rama