I have a tough problem that I'm not sure how to solve. Our organization tracks the reporting month in an odd way (First Tuesday in the month until the day before the next month's first Tuesday). I built workflows that determine the current and previous month inside of several paths and appends the month start and month end to the data in that reporting period's stream. All is well and good with that, but the ask has grown.
I now need to show quantities of actions and failures for a larger scope of time and generate these figures on a weekly basis. Because some of our actions can be backdated, previous month's data can change. Sounds fun, right?
So, I built a flow to determine the start and end of a reporting month and the data looks great, but what I need to do is to apply it to my main incoming data to assign which reporting month-year it belongs in.
For example, an action happens on 2022-05-01. It belongs to April's reporting window because 2022-05-03 is the first Tuesday of the month.
I'd love to have a way of taking the output from one stream (the year-month, first Tuesday, and last Monday) and use it as criteria against the action date in the main datastream to determine reporting month.
Action date: 2022-12-03 is between 2022-11-01 and 2022-12-05, to the reporting month is 2022-11.
Any thoughts on how I can accomplish this? How can I use the First and Last days of a reporting period to assign reporting month to my main datastream? Should I build these validations inline with my other datastream? I've attached my flow created to determine reporting month start and end from May of 2020 through April of 2030.
