Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a chart over a single dimension, which shows turnaround time if it's within the required window, or "Late" otherwise:
=if([DE TAT Days]< [TAT Required], [DE TAT Days], 'Late')
I want to color the bars based solely on the same fields used in the dimension, so that Late cases are red, 1 day prior is yellow, and earlier is green, like so:
if([DE TAT Days]< [TAT Required] - 1,Green(),if( [DE TAT Days]< [TAT Required], Yellow(), LightRed()))
However, the color expression always defaults to the else case (LightRed). This is true even if I replace [TAT Required] with a constant value (e.g. 7).
Try this?
= if([DE TAT Days] < ([TAT Required] - 1), Green(),
if([DE TAT Days] < [TAT Required], Yellow(), LightRed()))
Still goes all the way to the LightRed else case.
Hi Patrick
I did this by adding a separate expression for "over 60", 50 to 60 etc
Jo
can you share your qvw file where you are trying this, so that it will be easy to work on?
Hi Patrick,
Can you share your QVW file please.
Many Thanks
Karthik