Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

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

Show information from previous month

neromerob
10 - Fireball

Hi everybody. 

 

I´m building a workflow with shows me information that includes the current month (june by the time I´m writing this) but i need the information up to the last month 

 

Records.jpg

I know i could use somethin like "([month],-1,"month")" but not quite sure which function to use or even if it is better to use a "formula" or a "Filter" 

 

Thank You. 

 

 

4 REPLIES 4
CarliE
Alteryx
Alteryx

Hi @neromerob,

 

You can use a Dynamic Select for this with this formula 

 

!contains([Name],DateTimeFormat(DateTimeToday(),"%B"))

 

What this formula is doing is saying, do not select anything that contains the month name for the month of today. Attached the workflow- I don't have data in here, but you will see how the June field is removed.

 

If this solved your issue, please make sure to mark this as a solution :)

 

Thanks!

Carli
IraWatt
17 - Castor

Hey @neromerob,

Can you provide a sample data set try solutions on?

neromerob
10 - Fireball

some told me to used this formula and for now is working 

 

DateTimeAdd([month],-1,"month")

 

 

csmith11
11 - Bolide

Here's another approach that uses the Union Tool to Handle the Field removal Step. What is filtered out is handled with a traditional filter tool applied to the Field Names.

 

This will not just filter out June 2022, but it will also filter out anything else after today's date. Once we move into July, June will be added back in.

 

csmith11_0-1654714714156.png

 

Labels