community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Creating a Sum/Average of Last 30 days Per Day

Asteroid

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

Highlighted
ACE Emeritus
ACE Emeritus

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.

Alteryx Certified Partner
Alteryx Certified Partner

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

 

 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Asteroid

Awesome thanks alot :)

Labels