How to create a linear regression in Sigma

Are there any plans to add in any sort of regression (linear or otherwise) functionality?

If not, please consider this a feature request.

Here is how to create a linear regression in Sigma.
Let’s assume that we are plotting Sales on the Y axis, and we want to add a linear
regression trendline of Sales.
There is no wizard, so we will need to create 4 calculated fields:

x:

RowNumber()

// create this field on the X axis of the chart. Make this field hidden

Slope: create this field in the Summary as follows:

Corr([Sales], [x]) * Stddev([Sales]) / Stddev([x])

Intercept: create this field in the Summary as follows:

Avg([Sales]) - [Slope] * Avg([x])

Trendline: create this field in the Y axis of the chart, as follows:

[Slope] * [x] + [Intercept]

1 Like