We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Filter out previous month only

terrellchong
8 - Asteroid

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?

2 REPLIES 2
T_Willins
14 - Magnetar
14 - Magnetar

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

 

terrellchong
8 - Asteroid

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

Labels
Top Solution Authors