...
In our example, the measure is the peak_duration which will be plotted against the batch id.
Let's create a dashboard based on our worksheet, drag a chart item into the page designer and click on the pencil icon which appears when hovering over it.
Drag the columns you want to have in the x-axis and y-axis.
Add average and lower/upper limits
Right click on the chart open the Properties icon, go to the Advanced tab and click on Add .
To add the averge line, select peak_duration as field (i.e. your measure) and Average as value. You will then be able to customize the line style.
To add an upper and lower limit corresponing to +/- 3 standard deviations, from the Properties window click on add and then go the Stathistics tab. Select the desired measure and then choose Standard deviation from the Computation dropdown selection. The default limits are 1 standard deviation away from the average, to change that, click on the pencil icon and adjust the value to -3,3.
You can read the official documentation for more inforation (link)
This article explains how to create a control chart: a line chart showing the evolution of a measure with some reference lines representing the average of the sample, an upper line for the upper control limit, and a lower line for the lower control limit. The limits correspond to +/- 3 standard deviations.
In our example, the measure is the peak_duration which will be plotted against the batch id.
Let's create a dashboard based on our worksheet, drag a chart item into the page designer and click on the pencil icon which appears when hovering over it.
Drag the columns you want to have in the x-axis and y-axis.
Add average and lower/upper limits
Right click on the chart open the Properties icon, go to the Advanced tab and click on Add .
To add the averge line, select peak_duration as field (i.e. your measure) and Average as value. You will then be able to customize the line style.
To add an upper and lower limit corresponing to +/- 3 standard deviations, from the Properties window click on add and then go the Stathistics tab. Select the desired measure and then choose Standard deviation from the Computation dropdown selection. The default limits are 1 standard deviation away from the average, to change that, click on the pencil icon and adjust the value to -3,3.
You can read the official documentation for more inforation (link)