2 Replies Latest reply on Nov 13, 2018 10:31 AM by james.evans.10

    Counting the number of marks above or below a reference line

    james.evans.10

      Hi All,

       

      I have a sheet with a scatterplot showing test results from two groups of participants. I also added reference lines to show the 20th and 80th percentiles. I'd like to also provide the end user with a metric showing how many points fall above the 80th percentile and how many fall below the 20th percentile, and for that metric to change as the view is filtered. I haven't been able to figure it out yet so I'm hoping someone could help me out.

       

      Workbook attached, thanks!