1 Reply Latest reply on Feb 7, 2016 8:31 AM by Shinichiro Murakami

    Proportion of unique records that meet a criteria

    adam preston

      Hello,

       

      I am trying to figure out how to provide a ratio as a pie chart where the denominator is the number of unique users and the numerator is the number of unique users that meet a criteria.  I am familiar with doing this kind of thing in SQL using a group by but I am having a little trouble getting started here.

       

      Here is what I have done so far:

      • Created a calculated measure for calculating the "percentage trained" by averaging the values for Day 1 - Day 5. This
      • Created a filter for displaying just those records where percentage trained is greater than .75

       

       

      Thanks,
      Adam