All topics

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?

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?

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…

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.

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…

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

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…

Wonderware (AVEVA) historian to Canary? Options?

I've been tasked with collecting Wonderware Galaxy Objects' process values into Canary via a Wonderware/AVEVA historian data source. I know the AVEVA historian has a SQL interface,…

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

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

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

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