4 Replies Latest reply on Jul 30, 2018 11:05 PM by Elie Rahi

    Add Run Rate to Viz

    Elie Rahi

      I just need some assistance in putting together a vis. I need something that shows the figures for 2017, 2018 and target. The actuals for 2017 and 2018 are sourced from Salesforce and targets are sourced from an Excel spreadsheet - I've attached a workbook. In addition to the actuals, I would also like to add a run to the vis that extends the 2018 line to the end of the year that will estimate the future weeks based on the current 2018 weekly average.

       

      Also, would need to include two annotations that show:

       

      X actual 2018

      (+-)X% actual 2018 vs. 2017

      (+-)X% actual 2018 vs. target

       

      and

       

      X estimate 2018

      (+-)X% estimate 2018 vs. 2017

      (+-)X% estimate 2018 vs. target

       

      Something like this: