How summary data is calculated

On the Modify View page, you can add a column with summary data for any numeric column in your view. The following are examples of the calculated values you can specify:

• Total – total of all values for the interval

• Average – average of all values for the interval

• Minimum – minimum value in the interval

• Maximum – maximum value in the interval

• Range – maximum value in the interval minus the minimum value in the interval

The interval is determined using time stamps in the view:

• Start time is the time stamp of the previous row

• End time is the time stamp of the current row

The screen shot and table below illustrate the relationship between the time stamps and the calculated values. In this example, two columns were added, Volume 1 - Minimum and Volume 1 - Average. Both are based on the Volume 1 column. The current row is the row whose time stamp marks the end of the time interval. The time stamp of the previous row marks the beginning of the time interval. Volume 1 - Minimum takes all the data values between these two times, finds the minimum value, and populates the Volume 1 - Minimum column for the current row (that is, the row of the end time). Similarly, it calculates the value for Volume 1 - Average column by averaging the Volume 1 values between the start time and end time and populates the Volume 1 - Average column for the current row.

For information on how to add a column of summary data, see Add a data column.