Avg function inside set analysis

[#1]

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!

[swuehl · Accepted solution]

Hi,

try something like

Interval(Avg({$<status={'old_done', 'old_notdone'}, Flags={2}>} Tickets.indicatedTime),'hh:mm')

Regards,

Stefan

[#3]

Hello Stefan,

I think its correct.

Thanks!