Creating a Sum/Average of Last 30 days Per Day

[Rohitpm]

Hi Guys

I am trying to create a sum/average of a column for each day based on the past 30 days (or whatever interval i might chose next) from that specific date. Preference would be to do this in database. Is this possible i can quite think of how to solve this.

Thanks

Ro

[pcatterson · Accepted solution]

I don't know a way to do it In-Database since its a multi-row calculation, but here is a method you can use that is local.

[MarqueeCrew]

https://gallery.alteryx.com/#!app/MovingCalculation/555e4b2e6ac90f17fc94c89d

i posted this macro a couple of years ago at an inspire conference. 

Adam posted a macro in his pack too at chaosreignswithin.com

cheers,

Mark

[Rohitpm]

Awesome thanks alot :)