Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Filter out previous month only

7 - Meteor

I have a set of data which I put it as byte size which makes it turns in 1 2 3 4 5 as belows.


However let's say I only want the month on 6 only, how can I do that when Im currently at 7 and wanted to filter out 6 only?

13 - Pulsar

Hi @terrellchong,


A couple of different methods below:  Filter using latest month and Filter using current month.  The first only returns only the latest month; the second looks at the current month and returns the previous month.


Filter previous month.png


7 - Meteor

Thanks ya, I am able to continue with my workflow now!