Creating a Sum/Average of Last 30 days Per Day

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

Tips and Tricks

Transformation

Preparation

In Database

In-Database

Accepted answers

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.

MultiRow30.yxmd

All comments

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.

MultiRow30.yxmd

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

Awesome thanks alot

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15879

MarqueeCrew 13708

apathetichell 13703