Hello all,
I’m trying to build a graph that determines which weekdays an employee has not submitted time during the extent of his or her hire period. For example, if Employee A was hired on Monday, 11/09, and today is 11/11, the graph would check to see if Employee A has a time entry for the 9th, 10th, and 11th.
Of course, the example is simplified quite a bit. In reality, I’m running this graph for 800+ employees going as far as back as 2004.
Right now, I’m trying to use the loop function with a parameter called USE_DATE. The idea is that while USE_DATE is greater than the minimum hire date that the graph will continue to run. My issue is that I can’t find a way to change the USE_DATE parameter and have it apply to the next round. USE_DATE always acts as today() regardless of reformatting at the end of the loop.
Does anyone have any suggestions as to how I can tackle this mammoth-sized problem?
Thanks,
Reese