Calculation Server

Asset-Based Calculations with Output to Multiple Tags

Hi all, I’m working on setting up asset-based calculations in Canary and could use some guidance. My goal: Apply the same 5m calculation (e.g. 5-minute average of Real Power) across multiple assets…

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…

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.…

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

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?…

Is there a way to get the quality of the result of an Aggregate function?

I am trying to do something like this if(IsQualityGood(DeltaBounds('[Energy.%Asset%.EnergyMeter]', '1h')),DeltaBounds('[Energy.%Asset%.EnergyMeter]', '1h'),if(IsQualityGood(Delta('[Energy.%Asset%.…

• Answered

Calcs and Events - Latch value

I have a complex event trigger that I am having difficulty programming. I have a trigger that when the length has been reset (Previous length > current length - which we'll call A) and then the…

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…

Should IsQualityGood propagate the Quality of the tag?

We have a use case where we have two flow meters that we want to sum up. If one of them is Bad quality from SCADA, we want Calcs to treat it as zero. We did If(IsQualityGood('tag1'),'tag1',…

Trend Graph displaying only an Event Duration

Hello, I'm new to Canary, so please accept my apologies if this has been already discussed or answered (I could not find anything on this in the help center).…

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

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…

Event Hash and ID

We've been looking at pulling Events via the API. Here is a sample response from our system. We noticed there is an ID and a Hash. I don't see any documentation on what those represent.…

ResettingAnchoredInterval with Total2 Aggreggation

I've got a flow, and I want to get get an accumulated daily flow rate. So it goes up and up and up, and at 9am it goes back to zero and starts over. I'm pretty sure I can use…

Count Daily events

I have a system with a tag that produces 3 values: UP DOWN NoData And I want to count the number of times (within a day) the tag value switches from UP to DOWN or from NoData to UP.…

• Answered

Rollup calculation syntax

I'm trying to create a rollup calculation but I don't really understand he syntax and I can't find any examples. I have a virtual view with these asset types: one Company, with multiple Sites,…

• Answered

Quality of PreviousValue

Is there a way to get the quality of the PreviousValue of a tag in Calc and Events. I try to use Quality('PreviousValue('[tag]')'), but I get an error for this.

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

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