Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Average volume for the last 24 months

Sammy22
8 - Asteroid

Hello,

 

i need to calculate the average volume for a customer using the last 24 months. I tried to use a filter on the date but i will need to change this each month. My data looks like the below. How can i do this?

 

Order IdCustomerVolumeDate
2.32E+04a32/18/2019
32e23ea42/18/2019
e2e3a32/18/2019
e2e2a73/29/2019
23ed2eda43/29/2019
23ed23a35/2/2019
32ed23b225/2/2019
23ed2db35/2/2019
2.30E+03b45/2/2019
1231ewb35/3/2019
1 REPLY 1
PhilipMannering
16 - Nebula
16 - Nebula

Hi Sammy,

 

I think you're trying to filter your data dynamically. You could do this with,

datetimediff(datetimetoday(), datetimeparse([Date], '%m/%d/%Y'), 'mon') < 24

 

Labels
Top Solution Authors