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
The Canary Excel Add-in
Learn how to query data within the Canary System directly from Microsoft Excel. Pull raw data values, processed data values, make Event queries, or build your own custom reports.…
updated
2 yrs ago
607
Canary Academy
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
410
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
242
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
214
Excel Add-in
Leveraging the Excel Add-in (v21)
In this session, learn how to: Build and filter tag lists Pull tag properties Recall last values Query raw data values Use aggregates and processed data
2 yrs ago
166
Previous Coaching Sessions
Aggregate List (version 22)
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',…
updated
2 yrs ago
165
Excel Add-in
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…
updated
6 mths ago
153
2
Excel Add-in
Processed Data (version 22)
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…
updated
2 yrs ago
150
2
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
143
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
6 mths ago
1
reply
142
Last reply
Steve Mason
6 mths ago
Excel Add-in
Aggregate List (version 23)
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',…
updated
2 yrs ago
133
Excel Add-in
Tag List (version 23)
A 'Tag List' is a generated list of tags that will be used as the input for other functions in the Add-in, such as: Tag Properties Tag Data Context Raw Data Processed Data Value At Last Value Search…
updated
2 yrs ago
132
Excel Add-in
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
119
Excel Add-in
Tag List (version 22)
A 'Tag List' is a generated list of tags that will be used as the input for other functions in the Add-in, such as: Tag Properties Tag Data Context Raw Data Processed Data Value At Last Value Search…
updated
2 yrs ago
109
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
108
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
78
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
74
Excel Add-in
Tag List (version 21)
A 'Tag List' is a generated list of tags that will be used as the input for other functions in the Add-in, such as: Tag Properties Tag Data Context Raw Data Processed Data Value At Last Value Search…
updated
2 yrs ago
73
Excel Add-in
Tag Properties (version 23)
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.…
updated
6 mths ago
72
Excel Add-in
Raw Data (version 23)
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.…
updated
6 mths ago
71
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
70
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
Raw Data (version 22)
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.…
updated
2 yrs ago
67
Excel Add-in
Setting the Endpoint in the Excel Add-in
Where does the Set Endpoint configuration get saved to?
Big_Bird
Hi everyone! I post questions for the Canary Team to answer.
Big_bird
2 yrs ago
1
reply
65
Last reply
Steve Mason
2 yrs ago
Questions & Answers
Answered
Answered
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
57
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