Aggregated values

Aggregated values are the values from one or multiple data logs aggregated using the “aggregate” function. You can add an arbitrary number of values (columns) from multiple data logs.

First item in the table is always Interval End. Aggregated data log has always two dates: start and end of interval.

Then you can add as many aggregated items as you wish. Table has following columns:

Column	Description
Datalog/Alarm	Source datalog (or Alarm)
Tag	Source tag (or Alarm Severity)
Name	Name – eg. name of aggregated item
Description	Description of aggregated item
Unit	Unit (useful in trends)
Format	Format for numeric values use #.## notation
Function	Aggregate function (sum, avg, min, max, ..)
Type	Type of item eg. Numeric or String
Parameter	Additional format parameter for Type item
Alignment	Align item in data log view table to the left, right, or middle
Key	If you want to perform a search by this item, tick it please.

To add aggregated value for data log:

1. Select data log name in combo box
2. Select tag in combo box
3. Fill rest of the table

To add aggregated alarm count or alarm activation time

1. Select CAS Alarm
2. Enter maximum severity
3. Fill rest of the table

First, select a data log

Secondly, select a tag from datalog

Then fill in the Name, description and also the aggregate function:

Once you are done, don’t forget to also set up the data-log view, you can do it by clicking on the “Data log views” button:

You will be presented with data-log view definition, it is the same as when you define a data log view in data log definitions (please see chapter Data logs)

Simple Example:

In this example, we are aggregating data from 2 different datalogs “temp” and “humidity”