0 Replies Latest reply: Jan 23, 2018 10:55 AM by Samuel Washburne RSS

    Simple diagonal trend line

    Samuel Washburne

      Hi,

       

      I am trying to create a simple diagonal trend line as an expression based off a slope formula. I have see plenty of discussion threads about using the linest_m function but none of them explain how to add a 'hard' reference line. All I have is a date field and a target field (the target number of orders) and I would like the line to be plotted based off it's slope.

       

      Any and all help is greatly appreciated!

       

      -Ben

       

        

      Target ID (Late)
      0.55
      17.53
      33.97
      50.96
      67.95
      83.29
      100.27
      116.71
      133.70
      150.14
      167.12
      184.11

       

      Date
      43023
      43054
      43084
      43115
      43146
      43174
      43205
      43235
      43266
      43296
      43327
      43358