Loading

How to display trend lines with standard deviation added

Date de publication: Apr 30, 2025
Tâche

How to add standard deviation to the trend line.

User-added image

Étapes
The following is an example of setting a trend line and a trend line + standard deviation (σ) for Sales and Profit scatter plots.

1. Set Profit to Columns.
2. Set Sales to Rows.
3. Select Menu > Analysis > Aggregate Measures.
4.Create a calculated field and name it Slope. 
WINDOW_COVAR(SUM([Profit]), SUM([Sales])) / WINDOW_VAR(SUM([Profit]))

5. Create a calculated field and name it Intercept.

WINDOW_AVG(SUM([Sales])) - WINDOW_COVAR(SUM([Profit]), SUM([Sales])) / WINDOW_VAR(SUM([Profit])) * WINDOW_AVG(SUM([Profit]))

6. Create a calculated field and name it Standard Deviation (σ).

WINDOW_STDEV(ATTR([Sales]))

7. Create a calculated field and name it Trend Line +σ.

[Slope] * ATTR([Profit]) + [Intercept] + [Standard Deviation (σ)]

9. Set Trend Line +σ to Rows.
10. On the Marks card, open Trend Line + σ and the mark type to Line.
11. Right-click Trend Line +σ on Rows and select Dual Axis.
12. Right-click on the right axis and select Synchronize Axis.
13. Right-click on the right axis and uncheck Show Header.
14. (If needed) Open Analytics pane and drag Trend Line to Sales of Linear.

Numéro d’article de la base de connaissances

001458671

 
Chargement
Salesforce Help | Article