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
SOLVED

Filter out previous month only

Highlighted
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.

terrellchong_0-1593656885612.png

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?

Highlighted
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

 

Highlighted
7 - Meteor

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

Labels