Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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