Questions & Answers Category

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

Opening a new application/chart and passing date/time range

Hi! We have a customer that is looking to open a screen with the same time range as the screen that is requesting the opening. For example: User finds a peak value over a period of a specific day on…

Missing 'End of Event' Email Notifications

Hello, we have been configuring a bunch of Event alerts for the first time. We are now trying to fine tune our trigger parameters and noticed something strange.…

Excel Add-In Missing API Token Option

I've been trying to connect through Excel. I'm on the same local network, have the admin client installed on this same machine and I can access the admin service and see the main historian machine.…

• Answered

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…

axiom export data & canary excel add in getting failed for bulk export

Hi, I need to download raw data of 393 tags of one month data. when I tried raw data on aggregate interval, it was creating duplicate time stamps on excel export and get canceled the download with a…

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

Store and Forward Buffer

Hi, I upgraded a dev server to the new Store and Forward (S+F) system and want to understand how the buffer behaves. It does its job of storing and forwarding as it says on the tin,…

Changing Tag (from Ignition project) name before entering Canary Historian

We've got existing systems that did not use historian database capabilities and I am introducing the concept to the business units. I understand the concept of data historians,…

Axiom Tab Auto Navigate

Good Day All, I have an Axiom application with multiple tabs. Is there any way for a script to run that cycles through displaying each tab at a constant rate? Display tab1, wait 20 seconds,…

Password reset

Would anyone know how to reset a password from the Canary Administrator tool when it was lost?

• Answered

Canary Link tag

Hi @Steve Mason , We done Ignition upgrade from vision to perspective version. But the issue I have is, when people created the Perspective tag during the design and testing time,…

• Answered

Error tags OPC Collector

Good afternoon! We are carrying out a historization project with Canary, and we are experiencing some errors in certain Tags. We would like to obtain support to solve and remove the errors from…

CSV Collector Propertynames and PropertyOffsets

I'm a newbie, Can someone give me an example of how to use propertynames and propertyoffsets in SAF_Import.config file?

Documentation/Examples for Aggregates

We are trying to validate aggregation methods for a statistical tool we are building. Is there any documentation and/or example math available to validate the TimeAverage2 aggregate function? Thanks!

Filtering on View

Lets say I have a view with two different types of compressor Type1 and type2.. Type1 sends 5tags and type2 sends 6tags.. How can I create a new view with that has only type2...…

Documentation/Examples for OPC Data Transformation

We have an OPC DA Collector and an OPC UA Collector. Both are pointed to control systems that use digital states (i.e., 0 = off, 1 = on). In Canary, we'd like to store the string representation…

Is there a limit (6?) on # of properties for an event?

We setup an event in Canary under calcs & events and tried to backfill but it immediately went live without adding any events. If we removed properties from the event it worked.…

Issues with Aggregation & Resolution

We're having some issues with null-handling and data aggregation. We automatically aggregate the data to control the number of samples. For example, we try to ensure that we are asking for around…

API Issue

I'm using the Views REST/HTTP API and am getting an odd difference in timezone behaviour when requesting historical data. If I send the following request...…

RegEx Samples & Naming Standards

Are there any examples of Regular Expressions being used in Virtual Views? Since there are various RegEx standards and since the way the asset selectors work isn't always obvious,…

Example on Rollup

Can someone please show me how to use Rollup function in Calc

Yokogawa ExaOPC integration to Canary Historian

Hello, Can Canary database connected to Yokogawa ExaOPC software?…

Merging Axiom Apps

Is it possible to merge two axiom apps in one so that we do not have to repeat the work?