Assign to Initial Response Interval

Content

Hello everyone,

 

I am trying to reproduce Average time for "Assign to Initial Response" Interval in the attached report. However it is the only column that returns me 0 seconds results. I use interval type = 3 and the following expression 

to_number( to_char( sum( if( inc_performance.intv_type = 3, date_diff( inc_performance.time_end, inc_performance.time_start ) ) ) / if( sum( if( inc_performance.intv_type = 3, 1 ) ) <> 0,  sum( if( inc_performance.intv_type = 3, 1 ) ) ) ) )

 

Have ypu ever come accross the same issue? Is interval type 3 counting only number of incidents and not time?

 

Thank you very much for your potential ideas.

 

Christos