Hi everyone.
I´m fairly new to the forum, and it has been helping me heaps with Alteryx.
I managed to create and successfully run a Batch Marco for a data set I have. But I can´t get it to work with two control parameters looping 2 different inputs of controls, one for each control parameter. The Workflow runs without errors and it outputs part of the expected output, but not exactly.
I cannot share details about the data i´m working with, but I´v attached my Batch Macro and my Workflow with some commentary.
Long story short, the sheet is basically a data log for around 80 operators. It registers, with a unique ID, every operators actions with a time stamp, for each work shift for each day.
Example: ID 50 - John Snow - Night Shift - Dec 20th 2018 - Some problem appeared at 03:19:15 - Started doing something at 03:23:59 - Finished doing it at 03:25:55
With the Batch Macro, I can calculate how many actions each operator did for each day and also the average time each operator took from the time a problem appeared to the time it started doing something, and the average time the operator took to finish doing what he started. So far so good.
But I also have to verify how many actions were log correctly, since the operator can start 2 or more different actions at the same time, messing with the real average time to solution. So I have a multi-row tool to check if the starting time of the next action is greater than the finish time of the previous action. Than I recalculate the averages for this now 'corrected' data log and join them all at the end.
The expected sheet is something like this:
Dec 20th 2018 - Night Shift - John Snow - did 100 actions - avg response time 200 sec - avg workaround time 800 sec - 89 actions were time registered correctly - corrected avg response time 100 sec - corrected avg workaround time 400 sec
If I were to run all this individually, id take me days if not weeks to change the filters for every operator, for every day, for every work shift.
My Batch Macro outputs all operator details with the averages, but only one operator for each day will have the corrected averages filled in.
It´s clearly something I´m missing in my workflow, but I can´t seem to figure it out.
Any help would be greatly appreciated!
Thanks!
ps.: I can´t upload any screenshots due to company policy. I can however, get the code for the macro and workflow attached. I´ll modify them and post them shortly.
