-
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…
-
Timer Since Last TVQ
Hey all! I created a set of calculations and an Axiom grid displaying a running counter since last TVQ. Basically, each digit (HH:MM:SS) has it's own calculation,…
-
Calcs & Events Tile (version 25)
Active - number of active calcs/events currently running Tags Writing - number of tags being written to the Historian Hourly Count - number of TVQs (timestamp value quality) written to the Historian…
-
Events In Progress
When using the Admin Client on the Calcs & Events screen, I would like an option to easily find all events currently in progress. It would be highly beneficial to have a filter specifically for…
-
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.…
-
Duration a Tag is Greater than a value
Hello, I am trying to create a calculation that will tell me the total time in the last 24 hours when a tag has a value greater than a set value (example 50) Has anyone done this already?…
-
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.…
-
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.
-
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…
-
Calc & Events Settings Screen (version 24)
Endpoints IPC - endpoint used by a local Views service to read events gRPC Admin (55340) - endpoint used specifically by the local Admin service for configuring settings and requesting status…
-
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.
-
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?
Welcome to the community!