3 Replies Latest reply on Feb 2, 2016 11:46 AM by Alexander Mou

    Working with Rank Function

    Felix Curran

      I'm trying to make additional use of the RANK() function in the following examples.

       

      • Show only the best rank (i.e. MIN() of RANK()).
      • Show the 5 above and below ranks based on the selected category. (e.g. if selected category is rank 10 then show rank 5-15).
      • Show only the worst rank (i.e. MAX() of RANK()).

       

      I've set up a test workbook for you to play with to try and figure this out, this is attached to the post and a screenshot of the main dashboard is below:

      2016-02-02_09h28_11.png

       

      Regards,

      Felix