-
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…
-
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,…
-
Axiom Trend Graph
My tag output oscillates between the integers 0 and 1. Is there a way to view the historical data in Axiom without a line connecting the data points? Currently I am trying to manipulate a trend to…
Have a question? Ask it here. Or reply and share your knowledge