-
Google Sheets Plugin
Add a plugin for Google Sheets.
-
Excel Add-In Only pull when needed
Right now, if I pull historical data for the previous month (say, raw values). Then I go to a new cell and type in '=1+1'. When I hit enter, Canary will repull the previous month data.…
-
Search for tags by properties
In Axiom, if you enable properties in the tag picker list, search queries will look in both the tag name and the properties (like description). In the Excel Add-In,…
-
Processed Data (version 25)
The Processed Data function gives the user the ability to request aggregated/processed data from the historian, as opposed to raw data. For example, a user may want to know what the average hourly…
-
Processed Data (version 23)
The 'Processed Data' function gives the user the ability to request aggregated/processed data from the historian, as opposed to raw data. For example, a user may want to know what the average hourly…
-
Processed Data (version 24)
The Processed Data function gives the user the ability to request aggregated/processed data from the historian, as opposed to raw data. For example, a user may want to know what the average hourly…
-
Auth Flow to Use Custom URI Fully
Right now, you can set up a custom URI/URL for Canary by creating a DNS record that points to the Axiom machine and adding that URL to the Identity Tile redirect list.…
-
Defined Method for Editing Excel Add-In Data Pull
If I pull data into Excel using the Add-In, then I want to edit it. My options are to edit the formula directly, or, select a cell in the output array, then select a button at the top (and I have to…
-
Cache Credentials
I don't know if that's exactly the right term. But with Kerberos of OpenID authentication, laptops and machines usually have the ability to cache credentials.…
-
Option to filter raw/processed data
In Canary's Excel Add-In, we would like to be able to get the raw or processed data for one tag based on a filter expression. For example, I want to see the values of RSX-02.…
-
Excel Add-In Missing API Token Option
I've been trying to connect through Excel. I'm on the same local network, have the admin client installed on this same machine and I can access the admin service and see the main historian machine.…
- Answered
-
Custom defaults for Add-In settings
I know it's all personal preference, but for my customers and I, it feels like the default settings applied to a new data pull (like Processed Data) are always the exact opposite of what we want.…
-
v24 Excel Locked if user doesn't authenticate
If a user opens an Excel v24.0.1 workbook, or opens a new workbook and interacts with the Excel Add-In, it will open a browser. If the user closes the browser without authenticating (not knowing what…
-
Aggregate List (version 25)
Aggregates According to the OPC Foundation, aggregates "are methods that summarize data values. Common aggregates include 'average over a given time range', 'minimum over a time range',…
-
Aggregate List (version 24)
Aggregates According to the OPC Foundation, aggregates "are methods that summarize data values. Common aggregates include 'average over a given time range', 'minimum over a time range',…
-
Settings (version 24)
The Settings function allows the user to choose which Historian to connect to as well as the time zone in which to present data. The endpoint must be set before any requests can be made.…
-
Settings (version 25)
The Settings function allows the user to choose which Historian to connect to as well as the time zone in which to present data. The endpoint must be set before any requests can be made.…
-
Canary Excel Add IN LINK for download
This website has not been too clear on how to download the canary plug in for excel. Can someone please help me? I have the axiom desktop (which is not letting me log in - as soon as I click enter…
-
Field labels in Canary Excel Add-In difficult to read with "Dark Gray" office theme
This might be more of an MS Office issue than it is Canary where Excel doesn't use the write label text color to play nicely with the Dark Gray office theme but I noticed it looked like this (white…
-
Find Events (version 23)
The 'Find Events' function returns any events that have been pre-configured within the Canary Admin (See How To Create An Event). Event Type Will return any event type that matches the specified…
-
Find Events (version 24)
The Find Events function returns any events that have been pre-configured within the Canary Admin (See How To Create An Event). Event Type Will return any event type that matches the specified event…
-
Find Events (version 25)
The Find Events function returns any events that have been pre-configured within the Canary Admin (See How To Create An Event). Event Type Will return any event type that matches the specified event…
-
ComAddin Error with Excel
Excel displays a security warning and returns a ComAddin Error after installing Canary's Excel Add-in. How can I resolve this?
-
Getting Started (version 24)
Installing the Add-in Run the CanaryInstaller-*.*.*.exe and select Custom Install. Select Excel Add-in and deselect any other components if only wishing to install the Add-in.…
-
Set Endpoint (version 23)
Before the user can request data from the Historian, the client must point their add-in to the Views service residing on the historian server. This initial set up should only need configured once…
Welcome to the community!