You are here:

Value

The Value drop-down list contains a list of operations that can be applied to a query. The default query in all data series is the Value operation.

Average

Performs an averaging operation to selected data points in a given sample interval. For instance, if the sampling rate is set to every day, the average value of selected points over a 24 hour period will be returned.

For example, to average the value of the "Electricity demand" data for the sample period use Average("Electricity demand").

Count

Returns the number of raw data samples that exist for a given point during a sampled period. For components that do not provide sampling options, Count returns the entire start and end time range. The function works with a Data Set point type input. It can be used separately or with a Where clause condition and/or expression.

Count can be applied only to one point, otherwise a syntax error occurs if more than a single point is specified.

For example:

Count("OAT") determines the number of recordings available for the OAT point within a specified time period.

Count ("OAT") Where Value("OAT") < "low temp" determines the number of recordings taken that were below a specific temperature.

Delta

Solves for the delta or difference between a value of a point at the beginning and end of the sample period. To get the 15 minute average demand on a kWh point, use Delta("ELEC-CONS") * 4.

For example, If an energy point is 500 kWh at the beginning of January 1, and it is 700 kWh at the start of January 2, then the Delta for that day (January 1) is 200 kWh.

Delta can also be used to convert cumulative values into demand plots.

For example, have a cumulative kWh value that is logged every 15 minutes, you can use the Delta to show the derived 15 minute kW demand.

Max

Finds the maximum point value in a given sample interval.

For example, to find the highest value of "Electricity demand" found within each sample period, use Max("Electricity demand").

Min

Finds the minimum point value in a given sample interval.

For example, to find the smallest value in a sample period, use Min("Electricity demand").

Sum

Aggregates given values into a total.

For example, to sum all the point data for each sample period, use Sum("point").

Value

Returns the value of a point at each sample time, for example, Value("point").

Care must be taken when specifying the sample time for a data series. For example, if a room temperature log takes a sample every 5 minutes and the component has a sample interval set to every day starting at midnight, the component will show the first point for each day starting at midnight. If you want to see finer resolution, change the sample interval to once every 5 minutes. To see the average temperature for the entire day, Average should be applied.

More details