I was able to get a count if a meal break was achieved by the end of the day by using FirstSolvedOrder for the last time and using aggr for the date, shift and unit #. There are other fields that change that are causing the multiple update times that I need to keep.
I am looking to obtain the count of units that received a meal break in a certain time period (between 4hr from the start of the shift to 8hr from the start of the 12hr shift). The issue I am having is selecting the update time where the unit on that particular shift and day first received the Achieved status.
In reference to the table above I would expect to be able to count 2 achieved meal breaks but only 1 with the window(4h/8hr) as the day shift was just past 4hr into the shift and the night shift was achieved 11hr into the shift.
I was able to get a count if a meal break was achieved by the end of the day by using FirstSolvedOrder for the last time and using aggr for the date, shift and unit #. There are other fields that change that are causing the multiple update times that I need to keep.
I am looking to obtain the count of units that received a meal break in a certain time period (between 4hr from the start of the shift to 8hr from the start of the 12hr shift). The issue I am having is selecting the update time where the unit on that particular shift and day first received the Achieved status tellgamestop.
In reference to the table above I would expect to be able to count 2 achieved meal breaks but only 1 with the window(4h/8hr) as the day shift was just past 4hr into the shift and the night shift was achieved 11hr into the shift.
