Calculation Server

Backfill To vs Remove Old Data

How are Backfill To and Remove Old Data related? Below are the definitions from the documentation. So Backfill To will be leveraged anytime the calc is saved or the calc service is started up?…

Calculations stuck in Backfilling

I have several calculations that are stuck in 'Backfilling' and never go to Live Mode. This obviously means calculations that depend on them can't start.…

• Answered

Unable to read from transport connection

Hi, Has anyone come across this Error "Error during Live Update: Unable to read data from the transport connection;An exsiting connection was forcibly closed by the remote host" What may be the cause…

Use an attribute of a parent asset in a calculation

I need to reference the value of an attribute in a parent asset in my calculation. For this example I'm trying to calculation the contribution of the current element towards the total of all the…

• Answered

Event duration sum

Hi, is there a way to total all the durations of an event that occurred within a time period. For example, I have an event triggered for downtime of equipment and I'd like to sum up the total…

Date & time functions in calculations

I'm trying to calculate approximate sunrise/sunset times for each day of the year for a solar generation application. I have them worked out in Excel and need to transfer the calculations to Canary.…

• Answered

Simple calculation. Don't understand where the results go

I'm new to Canary and trying to understand how the asset model and calculations work. I've got Solar PV data coming in for 2 inverters with a number of strings of panels on each inverter.…

• Answered

Time Since False

I've got a use case where I want to keep a running timer of how long a piece of equipment has been off. There is a tag for status: 1 = running, 0 = off.…

CanaryAnd, and, &&, &

As far as I can tell, there are at least 4 ways to do an AND operation in Calculation: CanaryAnd, and, &&, &. Similarly for OR (CanaryOr, or, ||, |). And not equal has != and <>.…

Time a bool is true!!

V23 User I have a machine status, if true, the machine is productive, false if not productive. I want to periodically calculate the percentage of the current day the bool is true or machine is…

Accessing Calculated Tags

I have created a few calculations within my Cals & Events Tab. I was wondering if it was possible to access these tags within Axiom. If so, how would I be able to do this?

Count Number of Changes in String Tag value

We are doing a thruput improvement project and trying to find a way to calculate how many serialized units move thru our workcells. The most robust signal we have to track this with currently is a…

• Answered

Interpolated Bounding Values using SteppedInterpolation

Hi Everyone I know that Canary can do Simple Bounding and Interpolated Bounding when it's aggregate some time series. I supuse that it use SlopedInterpolation method (described by the OPC Foundation…

Send reminder emails with Calcs & Events service

I have a system which contains water quality sensors that will tell the process engineers when water filters need to be changed. I have set up email alerts to notify them when the water quality meets…

Data Compression

Hi Everyone, I have some data showing that during the night, the hourly scheduled calculations give me a result of zero. When I check the data the next day,…

Min Duration in Event with 3 Conditions

Hello everyone, I have an event that I need to create which must meet three conditions for at least 5 minutes: The first is that the data quality of variable A is Good.…

Parent-Child Assets and Calculations

Hi Everyone, I need to understand how to create rules for parent-child relationships between assets. I can't find any useful examples in the documentation, forums, or on YouTube.…

• Answered