4 Replies Latest reply: Feb 24, 2015 1:51 PM by Justin Kelly RSS

    Employee Scorecard vs Score of Prior Date

    Justin Kelly

      Hello!

       

      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

       

      sum({<REPORT_DATE={'$(vLastWorkday)'}>} QUANTITY)

       

      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!

      Justin

       

                                                                                                             

      EMPLOYEEDATESTATIONQUANTITY
      A02/14/2015134
      B02/14/2015234
      C02/14/2015325
      A02/15/2015228
      B02/15/2015343
      C02/15/2015141
      A02/16/2015131
      D02/16/2015227
      C02/16/2015339
      A02/17/2015126
      B02/17/2015249
      C02/17/2015329