Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
Im doing a bug tracker report and i have some difficulties with close tickets statistics.
First of all, I filter close tickets with set analysis: Count({$<status={'old_done', 'old_notdone'}, Flags={2}>} TicketNumber)
Second, Average time is generated as Interval(Avg(Tickets.indicatedTime),'hh:mm'). But this formula takes time on open tickets too... So, could I merge both functions into one to calculate average time on only close tickets?
Thanks in advice!
Hi,
try something like
Interval(Avg({$<status={'old_done', 'old_notdone'}, Flags={2}>} Tickets.indicatedTime),'hh:mm')
Regards,
Stefan
Hi,
try something like
Interval(Avg({$<status={'old_done', 'old_notdone'}, Flags={2}>} Tickets.indicatedTime),'hh:mm')
Regards,
Stefan
Hello Stefan,
I think its correct.
Thanks!