3 Replies Latest reply on Jan 4, 2019 6:49 PM by Chris McClellan

    Highlighting Spikes in a Line Graph

    Wong  Tze Xiang

      Hi guys,

       

      So i have made a line graph depicting sales over time, and i would like to know if its possible to make a feature that will highlight spikes or dips. I know this can be done with deviation but is there a way to compare data to the average deviation of only the past 6 months before any point. and if the change is greater than a set amount it will be highlighted.

       

      For example,

      Capture (1).PNG

      this is using superstore data. i want to have a feature where sept 2016 would be highlighted as sales spiked from aug(31k) to sept(73k) which is a lot more compared to the average change from march - aug