Aggregating Data

The configured push receiver uses FTP/SFTP to push the CSV files to the SDM server on which the Report Manager application runs. Before Report Manager can aggregate the data, it must identify new files, add them to a files table, and load them into the reporting database.

Data Type Aggregation Behavior

Below is a table of data types, and the aggregation behavior for each type.

Data Type	Aggregation Behavior
Dimension	Dimensions cannot be aggregated
Identifiers	Identifiers cannot be aggregated
State	The most recent state value
Boolean	The most recent boolean value
Count	The sum of the integer values
Range (i.e. 0-100)	The average of all values
Current value	The average of all values
Capacity	The average of all values
Index	The most recent index value
High water mark	The maximum value
Maximum rate	The maximum value
Low water mark	The minimum value
Minimum rate	The minimum value
Percentage	The average of all percentage values
Rate	The average of all rate values
Latency	The average of all latency values
Ratio	The average of all ratios
Speed	The average of all speeds
Temperature	The average of all temperatures