Setting up a Time Series Analysis Service
Navigate to Analysis Services, and create a new one. After completing all its standard attributes, open its Results Options tab and select Time Series as the Analysis Type
Interpolation. Graph Smoothing
You can also select the type of interpolation you want
Basis smooth, the line does not necessarily pass through the given data points
Cardinal smooth, the curve always passes through the given data points
Linear spiky, connects each pair of points with a straight line
Use Case
Consider a Compressive Strength test on concrete Samples, 3 per test, over a time period, measured regularly. We need to plot the average strength for the 3 tests, the standard deviation as error bar on the Average; the corrected average; and reference sample strength
Complete the graph and axis titles accordingly
Data Table Definition
Proceed to lay out the graph by defining its columns
- Index
Define the x-axis Index to which the graph will be plotted first, Age in this example
NB There has to be an Index row, select it on the Column Type lookup which will be the X axis units in the spreadsheet to be imported for the Analysis
- Data columns
Follow up with the data columns, these are the lines that will be graphed - give each the Data column type and appropriate title
If the value is a whole number, select Number for the Data Type, Float if it is a rational number that includes a fraction
- Average
If the column is an Average, select that as Column type - it will be used to differentiate it in colour from the other data lines
- Error Bars
You may also add Error Bars to Average curves, and table some results and Hide them without plotting them
Assign custom colours to lines in the right hand column. If no colour is given, the line won't be drawn and just it's data points plotted
- Hide in Plot
Hide values that you do not want to plot, maybe becauses it is on a different scale or type Text. These values will only be tabled but not graphed
- Text
One can also have text values tabled for the measuring point, e.g. Chloride Penetration in this example
