topic Avg function inside set analysis in QlikView

Avg function inside set analysis

Thu, 27 Oct 2011 10:01:00 GMT

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!

Avg function inside set analysis

swuehl — Thu, 27 Oct 2011 10:06:46 GMT

Hi,

try something like

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

Regards,

Stefan

Avg function inside set analysis

Thu, 27 Oct 2011 15:44:27 GMT

Hello Stefan,

I think its correct.

Thanks!