Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Identifying latest 12 months from date column

Sharathkrishnan
7 - Meteor

I have 3 columns product,date,sales

There are 3 products.

Each product has 5 years of data month wise

i want to create a new column and if any products last year(12 months) sales value is 0 I should update the value in the column as discontinued for that product..

 

How can this be acheieved in Alteryx

10 REPLIES 10
Sharathkrishnan
7 - Meteor

In the above output the solution fetches last year's records.but I want to fetch last 12 months..

Eg., if the data is till july 2021..last 12 months would be  july 2020 to july 2021..

if the data is till feb 2020..last 12 months would be  july 2019 to july feb 2020..

and also I should be able to change number of months I fetch...

sometimes I might want to fetch last 4 months also

Labels