Need help with avg

[#1]

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 ID	state	Days	Totals
1	Analysis	2
2	Analysis	3
3	Analysis	5	3,333333333
1	In progress	1
2	In progress	1
3	In progress	1	1
1	approved	10
2	approved	19
3	aproved	23	17,33333333
			21,66666667

Thanks In Advance,

Cristian.

[jaimeaguilar]

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]

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

Feeling Qlikngry?

How To /Missing Manual(18 articles)