All topics

Is there a way to create a Calculation with an aggregate function that ONLY considers TVQs with Good quality?

I have a calculation that uses this function here (TotalPerMinute('[localhost.Dataset.Power22]', '5m')), however whenever there is a non Good value withing the 5 minutes the result of this ends 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

Question on performing nested aggregations in the Calculation Engine

Hi all, I’m trying to calculate a “mileage” value in Canary. Mileage = sum of the absolute difference between each 2-second RealPower value and the previous one, aggregated over a 5-minute window.…

• Answered

Is there a way to define a Remove until in calculations?

Lets say i know there was a 7 day period in the past where all the calculated values were wrong, is there a way i can recalculate and remove that specific 7 day period without having to do the same…

• Answered

Use Calc output as input for same calc

Say I have a calc that calculates a modified pressure. I output that to a tag. Straightforward. But then I also want a tag that's a 3 hour rolling average of that modified pressure.…

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…

CanaryEvents.sqlite - Is it being purged?

Hello all Is the CanaryEvents.sqlite being automatically purged? Or would just keep growing indefinitely? Any ideas about what size is considered a limit to evaluate and purge (and how to purge)?…

• Answered

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

Bulk remove Calculations

Is there an easy way to remove multiple Calculations at once? Or is the only way to click delete on each one individually?

• Answered

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…

Calculation Ignoring Backfill to Date

I'm trying to delete all existing calculations, and backfill only to 5/1 but every time the calculations start backfilling from available data range 3/6

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…

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

Efficient querying for calculated interval data

We have a calculation writing 11 tags every 5 minutes to it's own dataset for our BI team. Since the historian is write-by-exception only, when querying this 5m data,…

• Answered

Date/time arithmetic in Calculations

Apologies if this is a silly question or if I'm repeating something I've already asked (I'm sure I asked something like this a while ago) but what is the best way to do date and time arithmetic in…

A tag that's value is the year data started

This is related to not being able to manually create tags. For filtering reasons in Axiom, I want to be able to have a tag that's value is the year the tags were added (i.e.…