ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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