Canary Community
Search
How to enable Javascript
Sign Up
Login
Welcome to the Community!
Search the community
Feedback
Forum
Knowledge Base
Explore & Learn
Roadmap & Releases
Home
Tags
Excel Add-in
Filter
Active
Newest
Popular
Most likes
Most replies
Most views
1
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.…
James Wise
Top Contributor
wise_james
13 days ago
15
1
Excel Add-in
0
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…
mkarangizi
mkarangizi
7 mths ago
1
reply
167
Last reply
Steve Mason
7 mths ago
Excel Add-in
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…
James Wise
Top Contributor
wise_james
10 mths ago
1
reply
47
Last reply
Steve Mason
10 mths ago
Bugs or Issues
Find Events (version 22)
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…
updated
10 mths ago
53
Excel Add-in
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…
updated
6 mths ago
76
Excel Add-in
12
Google Sheets Plugin
Add a plugin for Google Sheets.
merrittj
Top Contributor
merrittj
1 yr ago
31
12
Axiom
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?
Big_Bird
Hi everyone! I post questions for the Canary Team to answer.
Big_bird
1 yr ago
1
reply
54
Last reply
Steve Mason
1 yr ago
Questions & Answers
Set Endpoint (version 22)
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…
updated
1 yr ago
121
Excel 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…
updated
1 yr ago
146
Excel Add-in
Aggregate List (version 21)
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',…
2 yrs ago
434
Excel Add-in
AdHoc Events (version 21)
The 'AdHoc Events' functions allows the user to search for events on the fly that are not already configured within Canary's Calcs & Events service. View Select an available 'View' from the drop…
2 yrs ago
59
Excel Add-in
Find Events (version 21)
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…
2 yrs ago
30
Excel Add-in
Last Value (version 21)
The 'Last Value' function returns the most recent TVQ (timestamp, value, quality) for a set of tags. Input Range A reference to a range of cells containing a list of tag names typically generated by…
2 yrs ago
52
Excel Add-in
Value At (version 21)
The 'Value At' function finds TVQs that meet a set of criteria for a set of tags. If found there will be one TVQ (timestamp, value, quality) for each tag.…
2 yrs ago
79
Excel Add-in
Processed Data (version 21)
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…
2 yrs ago
63
Excel Add-in
Raw Data (version 21)
This 'Raw Data' function returns the raw data for a set of tags. The raw data is a series of TVQs (timestamp, value, quality). If the data changes, a new TVQ is generated.…
2 yrs ago
46
Excel Add-in
Tag Data Context (version 21)
The 'Tag Data Context' function returns the following four fields for a set of tags: latest timestamp, latest value, latest quality, and oldest timestamp.…
2 yrs ago
24
Excel Add-in
Tag Properties (version 21)
The 'Tag Properties' function returns the properties and property values for a set of tags. A tag can have any number of properties defined by the logging source or coming from an external database.…
2 yrs ago
41
Excel Add-in
Set Endpoint (version 21)
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…
2 yrs ago
110
Excel Add-in
Overview (version 21)
The following is a brief description for each function contained within the Excel Add-in. Tag List - creates a tag list to be used in other add-in functions Tag Properties - returns all property…
2 yrs ago
73
Excel Add-in
Overview (version 22)
The following is a brief description for each function contained within the Excel Add-in. Tag List - creates a tag list to be used in other add-in functions Tag Properties - returns all property…
2 yrs ago
219
Excel Add-in
Overview (version 23)
The following is a brief description for each function contained within the Excel Add-in. Tag List - creates a tag list to be used in other add-in functions Tag Properties - returns all property…
2 yrs ago
245
Excel Add-in
AdHoc Events (version 23)
The 'AdHoc Events' function allows the user to search for events on the fly that are not already configured within Canary's Calcs & Events service. View Select an available 'View' from the drop down…
updated
6 mths ago
69
Excel Add-in
AdHoc Events (version 22)
The 'AdHoc Events' functions allows the user to search for events on the fly that are not already configured within Canary's Calcs & Events service. View Select an available 'View' from the drop…
2 yrs ago
37
Excel Add-in
Tag Data Context (version 22)
The 'Tag Data Context' function returns the following four fields for a set of tags: latest timestamp, latest value, latest quality, and oldest timestamp.…
updated
2 yrs ago
27
Excel Add-in
1
2
Next
Recent activity
Home
Feedback
Issues and Bug Report
Bugs or Issues
Product Ideas and Feature Requests
Data Logging
Virtual Views
Calculations & Events
Axiom
Data Connectivity
Excel Add-in
Forum
Latest News
Axiom Showcase
Questions & Answers
Knowledge Base
Version 23
Getting Started
System Admin Duties
Client Tools
Version 22
Getting Started
System Admin Duties
Client Tools
Version 21
Getting Started
System Admin Duties
Client Tools
Explore & Learn
Upcoming Events
In-Person Events
Coaching Sessions & Webinars
On Demand Learning
RFP Common Responses
Canary Academy
Previous Coaching Sessions
Project Boot Camp
Roadmap & Releases
Roadmap
Canary System Release Notes
Ignition Module Release Notes
Distributor Release Links
View all topics
Support Center
Open a Support Ticket
View Support Ticket Status