1 Reply Latest reply on Jul 12, 2017 9:36 AM by Matt Lutton

    How to calculate Rank inside window

    Aleksey Movchanyuk

      Hi all,

      I have the following dataset:

      Step
      ObjectStatusOther Columns ...
      1Point Asuccess...
      1Point Bsuccess...
      1Point Csuccess...
      1Point Dsuccess...
      2Point AAsuccess...
      2Point BBsuccess...
      2Point CCsuccess...
      3Point AAAAsuccess...
      3Point BBBBsuccess...
      3Point CCCCsuccess...
      3Point DDDDsuccess...

       

      Is it possible to calculate RANK of the rows inside window {Step} like this { FIXED [Step] : RANK([Object]) } I want to get result bellow

       

      Step
      ObjectRankStatusOther Columns ...
      1Point A1success...
      1Point B2success...
      1Point C3success...
      1Point D4success...
      2Point AA1success...
      2Point BB2success...
      2Point CC3success...
      3Point AAAA1success...
      3Point BBBB2success...
      3Point CCCC3success...
      3Point DDDD4success...

       

      Cheers,

       

      --Aleksey

        • 1. Re: How to calculate Rank inside window
          Matt Lutton

          Yes, it is possible.  Mock up a packaged workbook using your dataset, and look into the RANK() functions (Table Calculations).  If you're not familiar with Table Calcs, I can help you get it started/set up once a workbook is posted. Cheers!

           

          Rank Calculation

           

          You may just use the same calculation twice, with different scopes/directions via the "Compute Using" or specific dimensions selected when editing the table calculation.