SOLVED
Dynamically filter past 13 months
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
iacuoj47
5 - Atom
‎01-17-2024
10:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
Labels:
- Labels:
- Developer
- Help
- Optimization
- Workflow
2 REPLIES 2
binuacs
21 - Polaris
‎01-17-2024
02:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@iacuoj47 attaching a sample workflow
‎01-17-2024
05:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you!
![](/skins/images/12DF86F0CA96E81F3ABF675C1590B6DD/responsive_peak/images/icon_anonymous_message.png)