Retrieved Measures are used to collect data from the data sources you have connected to your Flow System. These measures are responsible for collecting, summarizing and storing data from the “outside world” in your Flow System.
When you configure a measure as a Retrieved measure, the Retrieval section of the Measure Editor looks similar to:
The following properties may be configured:
|
This determines how the detailed data (i.e. high-resolution data) should be summarized into the interval of the measure (e.g. hourly, shiftly, etc.) for reporting purposes. By default, Flow uses the Average aggregation method. |
|
The Data Source tag for which summary data is retrieved (this is usually populated during a drag n’ drop action of a tag from the Data Source Namespace, but it can be added and/or modified manually if required, or another tag can also be dragged over and dropped onto this textbox). |
|
This is a factor that the resultant summarized value is multiplied by in the case where scaling is required (e.g. simple unit of measure scaling). |
|
When retrieving data from a Data Source, Flow can use the value of another tag (or the same tag) to filter out unwanted detailed data. Flow will use the values in the Filter Tag and compare against the filter condition to determine whether the detailed data should be used in the calculation or not. |
Where a Data Source supports the use of Filter Tags, if you include a Filter Tag in the Retrieval Section, the following properties become available for configuration.
|
This is the comparator part of the filter condition. |
|
This determines how the detailed data (i.e. high-resolution data) should be summarized into the interval of the measure (e.g. hourly, shiftly, etc.) for reporting purposes. By default, Flow uses the Average aggregation method. |
|
This is used by Flow if all the detailed data is filtered out of a time period. Flow will use this default value for the measure value for that time period. |
Most Flow Data Source types represent tag-based time-series data. But there are also Data Sources which contain transactional data, and against which queries need to be executed to retrieve the required data. For a transactional-type Data Source, where the concept of a tag does not exist, the Retrieval section of the Measure Editor appears similar to:
|
The Data Source query that must be executed to return the summarized data for the interval with which this measure is configured. The query may also return all values for the interval (similar to how a time-series type Data Source would) and one of Flow's aggregation methods may be configured to summarize the detailed data. |
|
This determines how the detailed data (i.e. high-resolution data) should be summarized into the interval of the measure (e.g. hourly, shiftly, etc.) for reporting purposes. By default, Flow uses the Average aggregation method. |
Flow has defined a number of aggregation methods to standardize how detailed data is summarized into Flow.