3 Replies Latest reply on Jun 26, 2012 7:12 AM by Eric Bokobza

    Multiple averages but Single Count Distinct

    Eric Bokobza

      Hello,

       

      I have a data set that finds the average score for an agent on six different categories (efficiency, professionalism, etc.) over a certain period of time (month, year, etc.). I also want to add in a count distinct of the number of evaluations the agent had in that time. The problem is the count applies itself to each category so it shows the number of evaluations six different times instead of just once.

       

      Is there a way to get the number of evaluations to show only once and not for each category?

       

      I have attached a sample copy for review.

       

      Thanks.