rolling 12 months average

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Hope all are doing great.

I need your help on calculating rolling 12 months average score for my metric.

I am calculating average delivery % for each product.

i need to plot a graph on product dimension and the measure i need to calculate is last 12 months avg delivery %.

I have used the following expression to achieve that.

Delivery % = successfull tickets/Considered tickets

avg 12 months delivery % =

RangeAvg(Aggr(

(Count(DISTINCT{<[Invoice Date]={">=$(=MonthStart(Max([Invoice Date]),-12)))<$(=MonthEnd(Max([Invoice Date])))"},Category={'Success'}>}[Ticket Number]) /

(Count(DISTINCT{<[Invoice Date]={">=$(=MonthStart(Max([Invoice Date]),-12)))<$(=MonthEnd(Max([Invoice Date])))"},Category={'Considered'}>}[Ticket Number]) ,Product))

but unfortunately it is not giving the correct result.

Can somebody guide me with the correct expression.

Thanks,

Nani

Re: rolling 12 months average

vinieme12 — Mon, 06 Feb 2017 06:04:46 GMT

Give this a read

Average – Which average?

Re: rolling 12 months average

vinieme12 — Mon, 06 Feb 2017 06:05:53 GMT

or provide a sample app with expected output

Re: rolling 12 months average

Mon, 06 Feb 2017 06:25:05 GMT

Hi Vineeth,

Thanks for your reply.

I am off work today and i will provide the sample data once i reach office tomorrow.

Thanks,

Nani

topic rolling 12 months average in QlikView

rolling 12 months average

Re: rolling 12 months average

Re: rolling 12 months average

Re: rolling 12 months average