I was trying to create a bar chart that displays the top 5 employee in Green and the bottom 5 employee in Red color in one chart. I have one dimension (Employee) and the expression is the utilized hours that used by employee in percentage. Can anybody please tell me how to do it?
I was using the following in expression Background color:
'If (Rank(Sum(vTotalUtilization)) <6, Green(), if (Rank(Sum(vTotalUtilization)) > 5, Red())), but it turns out every bar's in Red color.
Thanks for your quick reply. The problem I have from this expression when I sorted by Y-value in Descending order, I could able to see the top 5, but the bottom 5 bars are not accurate. For example if I have 15 values and want to show the top 5 and bottom 5 values after enabling the X-Axis Scrollbar, I have to move the scroll bar to the right to see the lowest value. Is there any other way to tackle this?
Yes, this does help and thanks so much! One more thing though, I know how to add a reference line on a chart to show the targets or goals. But I don't know how to add a range, for example from your example, how to show a target utilization range hours that highlighted between 15-20?