I have data set up like the table below. I'm trying to build a scorecard for each employee that show their performance for the most recent day. I have that figured out with set analysis that shows their quantity for the last workday using
What I would like to do is show an employee's performance for yesterday and compare it to the last time they were at that station.
For example, for February 17th, Employee B had a quantity of 49 on Station 2. The last time employee worked Station 2 was on February 14th and he had a quantity of 34.
Also, Employee A had a quantity of 26 on Station 1 on February 17th, but the last time he was on Station 1 was February 16th.
Does any know an expression or something that I can do in the script that would work for both employees?
Thanks, Gysbert. What if there are multiple records for an employee for one station for one day? I suppose my actual data is more like the below, where this is a time stamp for every item completed at each station.
I tried adding SUM() around the QUANTITY in the FirstSortedValue expression and I tried AGGR() but I still couldn't get it to work.