Assign to Initial Response Interval
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.