2 Replies Latest reply on Jan 28, 2017 8:18 PM by msa s

    need some explanation on Rank,Size

    msa s

       

       

      what is 'rankofsales' is rank (sum(sales) doing here ?

       

       

      for example sales value:

      100

      300

      400

      500

       

      Rank(sum(sales)= rank(1300) ?

       

      any further explanation on using size()- rankfosales here, what does this do exactly here. ??

        • 1. Re: need some explanation on Rank,Size
          Joe Oppelt

          SUM(sales) is at the cell level.  In your screen shot the SUM(sales) for each customer is about 95K, 85K, 78K, 62K, 57K.


          RANK(SUM(sales))  ranks those values.

           

          When you are editing a calc, you can click on the function name (always in blue in the editor) and off to the right is a panel that explains what that function does, and the parameters needed for that function (if any).

           

          SIZE() tells Tableau how many rows are in that partition.  In your screen shot, SIZE() = 5.

           

          A really helpful thing to do when you are trying out what a function is doing is to display its value on the sheet.  Create a calc that just says SIZE().  Drag that to the text shelf.  And drag the [rankofsales] calc to the text shelf.  These numbers would then display on each row, and then you would see what the larger calc is doing.

          1 of 1 people found this helpful
          • 2. Re: need some explanation on Rank,Size
            msa s

                 i understood rank part thankyou