6 Replies Latest reply: Jun 2, 2017 1:31 AM by Sanjyot Paktar RSS

    Creating an explicit trend-line data column

    hughprior

      I would like to have an explicit trend-line data column. I know that I can automatically have a trend line on a graph (through Expressions -> Trendlines), but what I would like to explicitly have a column with this data in. I will give an example.

      Let's say there are 3 columns which I want: Date, Performance (in seconds), Trend (in seconds) - a calculated field, which let's say looks as follows:

      25/01/2011 5.2 5.0

      26/01/2011 6.1 6.0

      27/01/2011 7.4 7.0

      My guess is that functions like LINEST_M will help me get what I want, but I'm too novice to know how to do this.

      Thanks!