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 |
