0 Replies Latest reply on Nov 15, 2018 2:53 PM by Elie Rahi

    Run Rate Calc

    Elie Rahi

      I have visits to 10 different stores. I need a graphic like below that shows me cumulative visits to a particular store by week number (week 1,...,52):

       

      - 2017 visits

      - 2018 visits + a "run rate" based on the average weekly visits (in 2018) for the shop to forecast till the end of the year

      - Target visits

       

      In the annotations it needs to show:

       

      - The difference of visits between 2017 and 2018 (actual)

      - The difference of visits between 2018 and target (actual)

       

      - The difference of visits between 2017 and 2018 (run rate estimate) at the end of year

      - The difference of visits between 2018 and target (run rate estimate) at the end of the year

       

       

       

      I need a graphic for each shop. The spreadsheet is attached that should have all that you need.