BAR graph showing no data

[Anonymous]

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

[Clever_Anjos · Accepted solution]

Maketime(24,0) returns null -> Midnight of next day

Try using

If( DurationStefan > Interval(KPI_TIME/24) , LightRed(70), LightGreen() )

as background color expression