0 Replies Latest reply: Feb 10, 2016 2:56 AM by Kevin Bouwer RSS

    Rank Set Analysis Expression

    Kevin Bouwer

      Hi All

       

      I have the following expression in a straight table

       

      =if(PhaseValue = 0 ,0,max(aggr(sum({$<DefencePhaseSort = {$(#vPHASENO2)}>} DefenceTacklesMissed),PhaseValue,PhaseDim)))

       

      When trying to rank the data, i get the rank to equal 1 across all parameters

       

      PhaseDim is a dimension containing 13 separate parameters looking at Tackles Missed in each parameter

      The expression is looking at the max value from each PhaseDim


      I want to rank the top 4 parameters in a heat map


      For Example


      From the attached image

      I need to be able to rank the data


      Rank 1 = 'Quick Ball'

      Rank 2 = '2'

      Rank 3 = 'Opposition Lineout'

      Rank 4 = 'Opposition Kick Return'