Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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