Questions & Answers Category

Most efficient way to export large volumes of data with API

I’m working with a customer who needs about six months of historical data at a 10-second resolution for approximately 1,200 tags. I'm writing a script using continuation to retrieve the data,…

Axiom Panel Visible at certain times and blinking panel

I am making a dashboard and I am wanting to have a panel that is only visible at certain times of the day and then turns invisible outside that period of time.…

MQTT Collector logs only DBIRTH

Hello, I have modified the python script available in tahu-master python-examples-example.py to test the MQTT collector (23.2.1). The broker I am using is mosquitto.…

Canary to other historians?

Hi Canarians, Does canary expose an OPC /OPC UA/ MQTT Publisher to which we can connect from an external interface and write to our non Canary historian? I see the data collectors,…

Calculation Ignoring Backfill to Date

I'm trying to delete all existing calculations, and backfill only to 5/1 but every time the calculations start backfilling from available data range 3/6

Asset-Based Calculations with Output to Multiple Tags

Hi all, I’m working on setting up asset-based calculations in Canary and could use some guidance. My goal: Apply the same 5m calculation (e.g. 5-minute average of Real Power) across multiple assets…

SAF Import Fails with Datetime Conversion

Hi, I have been trying to import a CSV to create some local data tags for use with the data entry tool in Axiom. However, every time that I drop the CSV file into the directory folder,…

• Answered

Calcs and Events - Latch value

I have a complex event trigger that I am having difficulty programming. I have a trigger that when the length has been reset (Previous length > current length - which we'll call A) and then the…

Axiom custom controls

Is it possible to add custom controls (beyond simple symbols or images) in Axiom? I'm looking to integrate interactive UI elements—such as dropdown menus, radio buttons,…

Clicking on Events table n Axiom to open a display for the selected event

I'm trying and failing to do this using scripting in Axiom but maybe there's another way to do what I want (I'm running Canary V25.1)? What I wanted was, within Axiom,…

Data Entry Tags showing NoData for most recent Values

Hello, I'm having a problem where my tags that contain values from a data entry box show NoData when trying to display the most recent value in a Value Box.…

• Answered

Average Aggregate Type

Hello, I'm wondering how the Average Aggregate Type works. I assume it does not count zero values when the equipment is off but what triggers it to start averaging and what is the time span required…

Scheduled Report Management

Hi, Is there a way to view and edit scheduled Axiom reports , and the details of the chart/application and the user? I have many errors in the logs, all presumably from scheduled reports created by…

• Answered

Axiom No License Message

Hi Everyone I read this message on Axiom....but I have license until next year. What's happenning?

Read API Continuation

Can someone please explain how to use the continuation token returned by calls to /getTagData when using the read API? The docs (Canary Labs | Views Web API Documentation) don't include a lot of…

How to turn off Compression on SQL Collector Tags.

How to turn off Compression on SQL Collector Tags. I want all values from my SQL Collector. Example this happed today Timestamp Value 2025-03-10 11:41:55.978 31.79 2025-03-10 11:25:34.045 31.…

OPC-UA Collector Certificate

Good Day All, Version 23.2.1.2409 I have an OPC-UA server that I am attempting to connect to with my Canary OPC-UA collector. The OPC-UA server requires secure connection, leveraging certificates,…

Event Aggregate Value

Can you provide a list of all the event aggregate properties that are available to use in the email notifications for an event: I have end email notification template setup like this:…

• Answered

Axiom scripting class reference

I've been playing with scripting in Axiom and I'm wondering if there is documentation of the classes available, eg properties for all the control objects that can be put on the screen.…

Raw Export Returning Duplicate Rows

When using Axiom to raw export 3 tags we are getting duplicated rows for two of the tags but not the other. Is this a result of trying to perform a raw export for multiple tags, a known issue?…

Safe Direct Modification of MQTT Tag SQLite DB?

Can we safely modify the MQTT Tag SQLite database directly with proper precautions? We’re looking to implement a script that processes a CSV file of tags that need to be historized or removed,…

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

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

Count Daily events

I have a system with a tag that produces 3 values: UP DOWN NoData And I want to count the number of times (within a day) the tag value switches from UP to DOWN or from NoData to UP.…

• Answered