Add a Moving Average to a Chart (Report Builder and SSRS)
Applies To: SQL Server 2016
A moving average is an average of the data in your series, calculated over a defined period of time. In Reporting Services paginated reports, the moving average can be shown on the chart to identify significant trends.
The Moving Average formula is the most popular price indicator used in technical analyses. Many other formulas, including mean, median and standard deviation, can also be derived from a series on the chart. When specifying a moving average, each formula may have one or more parameters that must be specified.
The Tutorial: Add a Column Chart to Your Report walks you through adding a moving average to a chart, if you'd like to try it with sample data.
When a moving average formula is added in Design mode, the line series that is added is only a visual placeholder. The chart will calculate the data points of each formula during report processing.
Built-in support for trend lines is not available in Reporting Services.
Right-click on a field in the Values area and click Add Calculated Series. The Calculated Series Properties dialog box opens.
Select the Moving average option from the Formula drop-down list.
Specify an integer value for the Period that represents the period of the moving average.
The period is the number of days used to calculate a moving average. If date/time values are not specified on the x-axis, the period is represented by the number of data points used to calculate a moving average. If there is only one data point, the moving average formula does not calculate. The moving average is calculated starting at the second point. If you specify the Start from first point option, the chart will start the moving average at the first point. If there is only one data point, the point in the calculated moving average will be identical to the first point in your original series.