Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please find the attached file containg my applicsation-
I am facing problem please help-
1. If I click on B/C on "ticket type" dimension then BAR graph data is not coming but i am not facing problem for A in ticket type.
2. In the TICKET Detail straingt table colour coding is not coming perfectly-
Example- EF3304015 , EF3315393 - here resolution time is less than KPI time but still it is showing RED.
Please help
Maketime(24,0) returns null -> Midnight of next day
Try using
If( DurationStefan > Interval(KPI_TIME/24) , LightRed(70), LightGreen() )
as background color expression
Try using Count (ID) instead of NumericCount(ID) since for B/C your ID´s are strings, not numbers
use the count(ID) in the expression
IF KPI_TIME is measured in hours, then your color expression should be:
If( DurationStefan > MakeTime(KPI_TIME,0) , LightRed(70), LightGreen() )
EF3225969-color code is not coming properly
EF3225969 took 220 hours, should be marked as red, right?
no showing green but it should red
It´s red here
Which formula are you using at Backgound color?
Hi Anjos,
Thanks for constantly replying.
I have used formula which yoiu have suggested.
Please find the attached file.
Please let me knoiw if i am missing out.
Regards
need suggwstion (file atached)