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