-
What's the UoM for the Duration within the Events database?
Hello Canary team What's the UoM (or business logic) behind the duration attribute of the Events table within the Events database? Below are examples of a 1 second duration,…
- Answered
-
OPC/Custom Functions for Calc Server Error
When I create an application and use the DeltaTotalCount aggregate with the end time in the future (based on the duration and start time) The calculation seems to truncate to Now and works fine.…
-
Calcs & Events Tile (version 26)
Active Jobs - number of active calcs/events currently running Errored Jobs - number of calcs/events in an errored state Tags Writing - number of calc tags writing to the Historian Hourly TVQs -…
-
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?…
-
Duplicating Calcs Within a Calc Group
Is there anyway that you can make it so that when you duplicate a calculation that it goes below the calc you are duplicating? It is a pain to move the calc up the list when there are a lot of calcs…
- Released
-
Ability to send notifications via email when a calculation fails
Hello! It would be great to have a notification sent if a calculation fails. For example, I was playing with the system and modifying Events database settings that cause calculations to fail.…
-
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.…
-
“Preview Events” for Canary Calcs & Events
Troubleshooting Event logic is challenging because we cannot see how expressions evaluate over time before deploying. Other historian platforms provide a Preview Events capability that allows users…
-
Calcs string comparison like
I have a use case where I need to start an event when a flare pilot goes out. For whatever unknown reason, statuses are sent to us in string. And they're not uniform.…
-
Calcs & Events > Broader Filtering (By GUID?)
In Administrator > Calcs & Events, the Name Filter is helpful, but there’s no way to filter by GUID. This makes it painful when I’m trying to track down which calc a tag originates from,…
-
Clarify Notify Column for Backfill
Right now, the Notify column in the Calcs & Events > Browse Events shows email addresses for backfilled events even though Canary doesn’t send notifications during backfill.…
-
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',…
-
Canary Calculations %Path% Variable Support
Currently in Calculations, %Asset% is supported which makes building dynamic calculations easy. Still though, you have to manually type in the 'Path' portion even if it is selected above.…
-
Calcs & Events
This module covers Canary's Calculation service. The Calculation service acts as a client, connecting to the Views service to read data from the Historian to perform "jobs" which are outputted in the…
-
Add a CalculatedByGUID Reference
Add a line for the CalculatedByGUID to the Calculation Status pane for easy referencing of the Calculation's GUID without having to locate the output tags in the Historian.…
- Released
-
Add recalculate over a specific TimeRange in the past
It could be helpful to have the possibility to run a single calculation on a time interval in the past, without deleting or recalculating all values up to now.…
-
Folders in Calcs & Events
There should be a method for storing calculations in a folder structure so that the list does not get overly complicated.
- Released
-
Calcs & Events Tile (version 25)
Major updates to the Calcs & Events tile which are reflected in this article occurred in v25.4. If using versions 24-25.3.1 click here. Active Jobs - number of active calcs/events currently running…
-
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
-
Calcs & Events Tile (version 25)
Major updates to the Calcs & Events tile which are reflected in this article occurred in v25.4. If using versions 24-25.3.1 click here. Active Jobs - number of active calcs/events currently running…
-
Calcs & Events Tile (version 26)
Active Jobs - number of active calcs/events currently running Errored Jobs - number of calcs/events in an errored state Tags Writing - number of calc tags writing to the Historian Hourly TVQs -…
-
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.…
Welcome to the community!