6 Replies Latest reply on Jul 17, 2017 5:41 PM by Murong He

    Average of Distinct Values

    Murong He

      Hello,

       

      I am trying to create a calculated field that shows the average distinct count of [Case ID] by Employee for each group (see formula below). The AVG function does not give me the right number -- it calculates the value for each row (an employee can have many rows associated to his/her ID). I think that something like Window_Average would work, but when I tried replacing AVG with Window_Avg, I got an error. Any other ideas? Thank you!

       

      {fixed[Group ID]: AVG({fixed[Employee ID]:COUNTD([Case ID])})}