cancel
Showing results for 
Search instead for 
Did you mean: 

Moving average about the last x records

Former Member
0 Kudos

Hello,

I have a question regarding moving average calculation. The query contains information about tools, the date of the tool's breakdown and the quantity of produced parts with this tool.

Now I want to have an moving average over e.g. 3 tools back from the actual line.

1) Tool 1 - 2007-05-16 - 6.000 pieces - Average: 10k8k6k / 3 = 8.000

2) Tool 2 - 2007-05-13 - 8.000 pieces - Average: 9k10k8k / 3 = 9.000

3) Tool 3 - 2007-05-03 - 10.000 pieces - Average: 5k9k10k / 3 = 8.000

4) Tool 4 - 2007-04-24 - 9.000 pieces - Average: 9.000+5000 / 2 = 7.000

5) Tool 5 - 2007-04-03 - 5.000 pieces - Average: 5.000 / 1 = 5.000

Is this possible in BI 7.0?

Best regards,

Michael

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

Refer this

They are solving the same problem

Regards

N Ganesh

Answers (0)