6 Replies Latest reply on Aug 27, 2013 11:03 AM by Jason Scott

    Daily rankings of teams

    Jason Scott

      Hello All,

       

      I'm trying to figure out how to do this.  What I have is the need to rank on a daily basis teams that are most watched.  So I have a workbook with the 32 teams loaded in and the dates on which the event happened.  So now when I load it all together I run into the issue that the ranking calculation (index()) is only using the first partition so the teams will always be in the order of the first day in the charts.

       

      How can I have the ranking formula change on a daily basis based on the total sum of viewers?

       

      Thanks

      Jason