1 Reply Latest reply on May 16, 2018 12:32 PM by Jennifer VonHagel

    How to use the rank function on a measure

    Samrina Shah

      Hello,

       

      I am trying to find out how to use the rank function on a measure.

      I would like to rank the measure : Zone Total Visits

      Is this possible?

      I have attached a workbook!

       

      Thanks for any assistance!

        • 1. Re: How to use the rank function on a measure
          Jennifer VonHagel

          Hi Samrina,

           

          There are several versions of the Rank formula for you to choose from. This is a Table Calculation, and so the way it calculates (what it ranks over) will be dependent on what fields you have in the view. It defaults to rank based on descending order of the values of Zone Total Visits, but you can specify ascending if you like.

          Here is an example:

           

          Hope this helps,

          Jennifer