5 Replies Latest reply on Mar 28, 2018 11:18 AM by LaTonya Harrington

    Counting the number of scores above and below selected score

    LaTonya Harrington

      Hello,

      I would like to create a calculation that counts the number of hospitals that have a score higher than, equal to and less than the selected hospital score.  Example: I select hospital A, the score is 50.  How many hospitals have a score higher than, equal to and lower 50?

      "There are ____ hospitals with a median time higher than your hospital"

      "There are ____ hospitals with a median time equal to your hospital"

      "There are ____ hospitals with a median time lower than your hospital"