4 Replies Latest reply on Feb 20, 2013 2:26 PM by Shawn Aruch

    Compare average to individual value

    Shawn Aruch

      Hi,

       

      I’m  trying to build a report of employee statistics.

       

      I have page counts worked for each employee over a number of categories.

       

      What I’d like to do is compare each employee’s count to their department average? Also, manipulate the averages for some categories to go across multiple departments (ie category 1 is averaged at the department level, but category 2 has 2 averages, 1 for teams a and b and 1 for the rest of the company)

       

      I’d then want to graph these to share with the employees.

       

      The data is attached.

       

      If someone can point me in the right direction, I would be much appreciative.

       

      Thanks,

       

      Shawn