Simple diagonal trend line

benwashburne — Tue, 23 Jan 2018 15:55:00 GMT

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

topic Simple diagonal trend line in App Development

Simple diagonal trend line