Dynamically filter past 13 months

[iacuoj47]

Hi all,

Having some difficulties with this one, as it's a tad unique. my data source has multiple dates, monthly from 1/1/2022 - 1/1/2026. I'm running a report at the beginning of the month on the first business day, and it should reflect 13 months from the previous month. For example, if I'm running the report on 1/3/24, it should pull the dates 12/1/2022 - 12/1/2023.

I'd like to automate this process and not have to go into the Alteryx flow every month.

Let me know if any additional info is needed, and thanks for all the help!

[binuacs · Accepted solution]

@iacuoj47 attaching a sample workflow 

[iacuoj47]

thank you!