1 2 Previous Next 16 Replies Latest reply on May 30, 2017 10:16 PM by Jonathan Chung

    Help.. stuck on creating a time series data..

    Jonathan Chung

      Hi

       

      I am a bit stuck trying to create a time series based on below product ranking:

       

         

      ProductLast updateRank
      ABC04/12/20151
      ABC08/08/20163
      ABC24/04/20172

      into a time series so I can monitor the changes in ranking:

        

      DateRank
      31/01/20150
      28/02/20150
      31/03/20150
      30/04/20150
      31/05/20150
      30/06/20150
      31/07/20150
      31/08/20150
      30/09/20150
      31/10/20150
      30/11/20150
      31/12/20151
      31/01/20161
      29/02/20161
      31/03/20161
      30/04/20161
      31/05/20161
      30/06/20161
      31/07/20161
      31/08/20163
      30/09/20163
      31/10/20163
      30/11/20163
      31/12/20163
      31/01/20173
      28/02/20173
      31/03/20173
      30/04/20172
      31/05/20172

       

      Attache example only has 3 changes in the product lifetime, but in reality is much more.. so I cannot use the excel formula I have in the spreadsheet as I would need to create infinite amount of if-loop. Further complications is that the data will be blended of two tables, so there may be a bit of restrictions on what LOD formula we can use...

       

      Any suggestion will be appreciated.

       

      Many thanks

       

      Jonathan

        1 2 Previous Next