I have a workflow that brings in a report that is issued around every 1-4 hours. I say around as sometimes the report runs hourly, sometimes the report runs 3 hours later. This is scripted and intentional, for reasons I know not.
I need the reports from specific times only:
5:55am
8:55am
2:55pm
6:55pm
I need the results for that current run and the run previous. i.e. if the report runs at 9am, I only need the rows containing 8:55am and 5:55am, then when it runs at 3pm it needs 2:55pm and 8:55am
Output looks like this:
Is there a way to have this as a single logic?
The way I see to do it now is essentially 4 different workflows. I already created a formula for the "ReportAging" column. So I have Workflow 9AM do a filter series like so:
Where it pulls only the last 12 hours, then separates the most recent and the next previous.
This can then be modified for each run where the previous is 3 hours, 6 hours or 12 hours. It just seems unwieldy.
Again, anyway to have this wrapped up in a single bit of logic, or if I have to have multiple runs then is the Report aging calculation the best approach?
I've attached an extract of the file shown above.
