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.
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.
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
You can read the official documentation for more inforation (link)