rolling 12 months average

[#1]

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

[vinieme12]

Give this a read

Average – Which average?

[vinieme12]

or provide a sample app with expected output

[#4]

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