Rolling 30-day Average

[Anonymous]

Hi Guys,

I need to find rolling 30-day average based on the date but need to do achieve this in the script (not by using expressions).

Attached the sample data, which has file name, file size, file date and file type. File Name has two file types. I need to get the rolling 30 day file size average with respect to selections.

Alo I need to create a flag by comparing the normal average and Rolling 30-days average.

(If Normal avg >= Rolling 30-days avg then 0 otherwise 1) - Flag - (This is the reason that I need to achieve this in script itself).

Please help me out.

Thanks,

Siva.

[lorenzoconforti]

Hi Siva, do you need a 30 rolling average by File Type?

[sunny_talwar]

So basically you want that for each File Type, it should find the average of last 30 days on any particular date? File Names are different, that doesn't matter?

[lorenzoconforti]

If what you need is a rolling average by file type, please see attached

I'm sure this can be done much more efficiently but hopefully this helps

[MK9885]

Maybe this one if I understood correctly?

Find the attachment.

[Anonymous]

Thanks Lorenzo. But I want this rolling average by file date.

[lorenzoconforti]

Didn't it get answer on this other post? Rolling 30-days Average

Do you mind amending the Excel and insert in there what exactly you are looking for? It will be easier to understand