Questions & Answers Category

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?

Representing Stagnant Data Streams

We have a couple boolean tags in our historian that do not log any values unless it changes to a new value. Some tags haven't changed their value in a long time so when ever they are trended on axiom…

Different Regex Rules for different dataset

How can I use multiple views to create a new view and apply different regex for different views.

Events table in Asset Template

How to use events table in asset template to get list of historical events for each asset?

Conditional Counts

How can I create a conditional count i.e. count number of times the tag value was more than 50 for a week.

Get All Child Events in Axiom

Hello Everyone I need to retrieve all the events of an asset in Axiom, specifically for the child assets. I mean, I have Parent01, Parent02, etc., and for each ParentXX I have 10 child assets,…

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…

Do we create a separate view to create a calc dataset and use it with the other view to create combined view?

Hi , We know it is recommended to create a separate dataset for calc. But when we want to create a view with the actual view and calc view. Do we create a separate view to create a calc dataset and…

Should Rare updating data be meta data or a tag?

Lets say I have data point which maybe only update once a year but we require it for calcs and events. Do we create a tag or put it in meta data and update the meta data as an when required?

Using Meta Data in the Calc

Hi Can we use meta data and a tag to create a calc and event. If yes how can we do that?

Including event duration in end event email

Event Duration is available in the events table control in Axiom and in the event pull in Canary's Excel Add-In. We didn't find a way right off though to include the event duration in an end event…

Variable content errased not registered in Canary

I am having a problem with text data type variables in which the content is deleted in the SCADA system (PCS7) and the new value (no value) is not registered in Canary but instead maintains the value…

AssetBranchCount: Can we do like we want 1-3-4-7 levels in the asset framework in the Asset Label

ODBC without data on "data" table

Hi everyone, I'm trying to query from an ODBC client and I can only see data from the "aggregates" and "views" tables. When I try with the "data" table, the results are always empty.…

Exporting 24 Hour Events List

Hi Is there any way we can generate a CSV and send it out of Canary for events every 24H? Thanks

Data Compression

Hi Everyone, I have some data showing that during the night, the hourly scheduled calculations give me a result of zero. When I check the data the next day,…