Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help with avg

Hi Guys,

I need your help on how I can take an average of the days spent on resolving a ticket.

I want to get this by using only an expression.

For example for this table what I want to get is the 21,666 result , which is the sum of the average time spended by state of resolving a ticket.

Ticket IDstateDaysTotals
1Analysis2
2Analysis3
3Analysis53,333333333
1In progress1
2In progress1
3In progress11
1approved10
2approved19
3aproved2317,33333333
21,66666667

Thanks In Advance,

Cristian.

2 Replies
jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

you may need to use aggr as it is compound calculation (just like you said it is the sum of the averages),

take a look at the attached example

regards

robert_mika
Master III
Master III

=sum(aggr( avg(Days),state))

2015-07-31_224802.png

Feeling Qlikngry?

How To /Missing Manual(18 articles)