Best Practices

Value Box AggregateInterval/AggregateStartTime Configuration

What is the best way to configure AggregateInterval and AggregateStartTime to accurately display the current shift's total production and current total load count?…

Ignition - Backfill data from SQL database

We are hoping to use Canary historian for our existing Ignition system but are concerned about access to our existing data. Does anyone know if there's an accepted way to backfill existing data from…

• Answered

Remote Historian/Views/Architecture Options

I have multiple historians and a remote Axiom server. Is it better for Axiom to be pointed at a local Views instance which is connected to the remote historians,…

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…

Events Table Optimization

We are trying to optimize performance of the Events and Event Properties table, is it advisable to add Indexing and table partitions to achieve this?

Asset hierarchy definition help

I have a dataset populated by a CSV collector and I am trying to create a virtual view to put the tags into an asset hierarchy. The tag names are of the form CsvTag.<site>.…

• Answered

Scaling on Virtual View

Hi all- I currently have some tags I am historizing that have a different scale associated with them as I store (10x / 100x / 500x). I am currently using virtual views and I am looking for a way to…

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?

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

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

Get Tag Data Given a list or array?

Hi all, I'm currently working on a project that involves retrieving specific tag data from the historian. I have a list or array of timestamps for a particular tag,…

Using Axiom for Line Display

I want to use Axiom to show live time progress above production lines. Ideally, they will be on 24/7 and reset data at shift change Is there any issues with Axiom timing out if it is up on a screen…

Moving data between historians

Hello community! I'm exploring the Redundant Logging architecture, where a data collector+sender pair will move data to a primary and redundant historian servers.…

• Answered

Architecture Question

Multiple industrial sites with occasional network connectivity issues Multiple legacy control systems in place, all support OPC Business users want to see some process tags in a cloud BI system…

Canary as Site Historian vs others (Ignition, OSI PI, AWS)

For a Site Historian requirement, I am exploring the historians available in the market and understanding where each Historian fits well. Can anyone throw light on the following questions?…