Question:
How can I calculate the standard deviation in data recorded in the database, and display the result in a Report?
Solution:
This can be done via the Setpoint object’s SummaryFunc property in the Report, where you can apply several calculations on data returned by the Query. In this case, the standard deviation can be calculated with SummaryFunc property’s 7-ddSFStdDev option.
Note: The SummaryFunc property will only work if any option other than 0 is selected in the SummaryType property.
