Knowledge Base / Version 22 / System Admin Duties / Calculation Server

Calculation Group Status Screen (version 22)

updated 2 yrs ago

The Calculation Group Status screen is where users can create and configure calculations and/or events. Multiple calcs/events can be outputted from a single calc group provided they are independent of each other. If a calc is dependent upon another, it should have its own separate configuration.

STATUS

The 'STATUS' panel contains metrics for ALL calcs/events that are configured in the Calculation service.

Active Calculations - the total number of calcs/events that are running
Tags Being Written - the total number of tags being outputted by the active calculations
Events In Progress - the total number of events that are in progress
Total Event Count - the total number of individual events that exist in the database
Calculated This Hour - the total number of calcs/events that have been evaluated from the beginning of the current hour
Calculated Today - the total number of calcs/events that have been evaluated from the beginning of the day
Calculated Total - the total number of calcs/events that have been evaluated since the start of the Calculation service

CALCULATION STATUS

The 'CALCULATION STATUS' panel contains metrics for the current calc/event that is opened.

Last Modified - the date/time of when the calc/event was last modified
Enabled - True or False, if the calc/event is running
State
- Idle
- Waiting to Start
- Waiting for Sender Session
- Validating
- Checking for Dependencies
- Waiting on Dependencies
- Initializing
- Backfilling
- Live Mode
- Stopping
- Error
- Events Database Unavailable
Started Running At - the date/time of when the calc/event started running
Run Time - the amount of time the calc/event has been running
AssetPath * - the source view name along with any subnodes of where the asset is located
AssetType * - the name of the asset selected from the asset path
Number of Assets * - the total number of assets discovered given the selected asset type
Active Assets * - the number of assets that have outputted a value since the start of the calculation
Init & Backfill Time - the amount of time the calc/event was in an initialization and backfill state upon starting
Total Output Tags - the total number of tags the calculation outputs
Total TVQ's Stored - the total number of TVQ's (timestamp, value, quality) or updates stored since the start of the calculation
Total Properties Stored - the total number of properties stored since the start of the calculation
Total Evaluations Made - the total number of times the calc has been triggered to run
Last Evaluation Was At - the actual date/time of when the calc/event last evaluated
Last Evaluation Timestamp - the date/time linked to the last evaluation
Evaluations In The Last Minute - the total number of evaluations within the last minute (Now - 1 minute)
Events In Progress ** - the total number of events that are currently in progress
New Events Since Start ** - the total number of events that have occurred since the event started
Total Events in Database ** - the total number of events stored in the database
TVQs In The Last Minute - the total number of TVQs (timestamp, value, quality) that have been outputted in the last minute (Now - 1 minute)
Last Live Mode Evaluation Time - the amount of time it took the Calculations service to evaluate the last value
Avg Live Mode Evaluation Time - the average amount of time it has taken the Canary service to do each evaluation since the calc started
Max Live Mode Evaluation Time - the max amount of time it has taken the Canary service to do an evaluation since the calc started

*These fields are only applicable if the calc/event is asset-based. Assets must be defined within a Virtual View of the Canary Views service.

**These fields are only applicable for events.

Configuration

Name - a unique name identifying the calc/event
Asset Path - (optional) the source view and path for an asset-based calculation
Asset Type - (optional) the asset within the 'Asset Path' that will be used to apply the calculation to. As soon as an 'Asset Type' is selected, an 'Asset Tags' tab will appear in the left panel from which to select asset tags from.
Meta - properties to assign to output tags. Properties assigned here will propagate to all output tags within the calc group. Properties can be assigned using two methods. The 2nd method uses the property of another tag.
1. PropertyName::PropertyValue;;PropertName2::PropertyValue2;;
2. PropertyName::[SourceTagName].SourceTagPropertyName;;PropertyName2::[SourceTagName].SourceTagPropertyName2;;
Backfill To - the date/time the calc/event will backfill to upon initially starting
Frequency - the frequency at which the calc/event is triggered
1. Value Change - the calc/event is triggered when any tag in the expression changes or when specific tags change, depending on what tags are selected
2. Periodic - the calc/event is triggered on a set 'Interval' (1m, 1 hour, 1 day, etc.). An optional 'Offset' can be used to offset the interval. In the example below, the calc is set to run once a day at 6am.
Enable Time Extensions - allows for the last calculated value to be time-extended in the historian until the next value is calculated. Virtual time extension occurs approximately once a minute.
Delay - an amount of time the calc is delayed to prevent miscalculations due to different data stream rates. This delay should be set >= the highest latency stream in the calculation. This delay does NOT alter the timestamp of the output tag.
Remove Old Data - if checked, the old calculated data will be removed and the backfill process will be restarted for the calculation upon saving. (Note: A tag cannot be removed if it is currently being used by another client, such as Axiom.)

Calculation Expression

Evaluate - performs a test evaluation of the expression using the current values for all tags
Asset * - a list of all asset instances given the selected 'Asset Type'
Output path Asset levels * - controls the number of branches within the asset path to include in the output tag name, counting from the end of the asset path
Details
- Visible - all expressions are visible
- Visible When Selected - only the selected expression is visible where other are collapsed
- Collapsed - all expressions are collapsed
+ (Add) - adds another blank expression to the calc group
Variable name - (optional) the field to the left of the "=" sign. The variable name to assign to the expression for use in subsequent expressions. Only alphanumeric characters are allowed, and only letters are allowed for the first character.
Calculation Expression - the field to the right of the "=" sign. The expression used to determine the output of the calculation. Expressions can be copied and deleted using the icons.
Quality Override - allows the quality of the output tag to be overwritten
- Condition - a conditional expression used to override the quality based on the true and false boxes
- If true - the quality to be used if the 'Condition' is true. Values can include: Good, Bad, Uncertain, NoData, NoOutput, or any expression that returns a valid numeric quality.
- If false - the quality to be used if the 'Condition' is false. Values can include: Good, Bad, Uncertain, NoData, NoOutput, or any expression that returns a valid numeric quality.
Tag - the tag name that will be outputted from the calculation. The tag must be prepended with a DataSet name. If the DataSet does not exist, it will be created upon startup of the calculation. If the calculation is asset-based, the tagname must include %Asset%.
- DataSetName.TagName
- DataSetName.%Asset%.TagName
Type - the data type of the output tag. If a data type is not selected, the service will default to the type that best fits the value.
TS (Timestamp) - allows the user to override the timestamp of the output value using a relative time. Timestamps can be normalized to the second (s), minute (m), hour (h), day (d), week (w), month (month), and year (year). For example, a timestamp of "d" would normalize to midnight of the current day. "D-1d" would output a timestamp of yesterday at midnight.
Meta - properties to assign to the output tag. Properties can be assigned using two methods. The 2nd method uses the property of another tag.
1. PropertyName::PropertyValue;;PropertName2::PropertyValue2;;
2. PropertyName::[SourceTagName].SourceTagPropertyName;;PropertyName2::[SourceTagName].SourceTagPropertyName2;;
Event - allows the user to create an event using the configured expression. (Note: An expression does not need to generate an output tag in order to create an event.)
- Is Event Start Trigger - starts the event whenever the expression returns True. If an End Trigger is not configured, the event will end when the Start Trigger returns False.
  - Min Duration - the amount of time that must pass with the expression in a True state before an event is triggered (Ex. 1 minute (1m), 1 hour (1h)).
  - Notify Email - a comma delimited list of email addresses to send an alert to indicating the event has been triggered
- Is Event End Trigger - ends the event whenever the configured expression returns True
- Is Event Start and End Trigger - starts and ends the event whenever the configured expression returns True
- Is Event Property - used to attach properties to the event. Properties MUST be assigned to a variable and contain the string 'EventDuration' for the duration parameter of the aggregate function. For example,

Functions

A list of all supported functions and aggregates. Hovering over a function will display a brief description for that particular function. Selecting a function will also provide a description below the list, as well as provide the syntax and format the function is looking for. Click the '+' next to the function to add it to the expression. Functions can be filtered using the Search bar.

Asset Tags *

A list of all asset-based tags available for the selected 'Asset Type'. (Note: This tab will not appear if an asset type is not selected.) Click the '+' next to the tag to add it to the expression. Tags can be filtered using the Search bar.

Operators

A list of all supported operators. Hovering over an operator will display a brief description for that particular operator. Click the '+' next to the operator to add it to the expression.