JavaScript is off. Many parts of this site require JavaScript to function properly.

Reports

Make sense of your data with several reporting options. Share your findings and improve your processes.

reports

Excel Add-In

The Excel Add-in provides access to tag information, raw data, aggregate data, and event statistics. A Microsoft Excel ribbon bar allows you to quickly get to the functions you need.

add trends
play_circle_filled

Quickly access entire lists of tag names, tag properties, and tag data context.

Watch Video
calculation trends
play_circle_filled

Access any Canary historian and extract raw data values for a set time period.

Watch Video
trend limits
play_circle_filled

With over 30 available data aggregates, select the desired processed data based on time interval.

Watch Video
aggregated data
play_circle_filled

Browse the existing Events service and filter results by multiple properties or search for undefined Events with the AdHoc Events tool.

Watch Video
close

Flow

Flow software helps simplify the centralization of key operational data from multiple sources and helps you share important findings across your organization. With Flow you'll connect to data on-premise or in the cloud, synch measures and KPIs, perform calculations and rollups, and then share information in reports and dashboards that can be viewed in multiple forms.

flow reporting software

Collect

Collect and collate information from multiple data sources automatically. Flow naturally connects to the Canary data historians, as well as SQL databases, online data stores, IoT, even Excel and text files. Like Canary, Flow also embraces manual data entry and even features a configurable input form. The Flow Information Platform maintains a single version of the truth for your analysis and decision making.

Calculate

Using the powerful Flow Calculation Engine, create calculated KPI measures from both collected and manually entered data. Perform "roll up" calculations, moving window calculations, future dated predictive calculations, and more. Add context to your KPIs by relating them to production events (e.g. batch, shift team, product changeover, etc.). Evaluate your KPIs against targets and limits, then flag areas of concern for further analysis.

Visualize

Flow prepares and packages information for fast operational decision making. Use either embedded reports for Axiom or standalone dashboards to turn measured data into actionable information that can change culture.

Share

For information on-the-go, use the Flow social media platform to communicate quickly with others. Now, key KPIs can be quickly sent to various team members for instant collaboration without having to wait for meetings or compete for attention in someone’s email inbox.

XL Reporter

editor

Created by SyTech, XL Reporter is built around the familiar environment of Excel and is recommended for automated reporting. The scheduler can automatically produce reports within Excel Workbooks, as encrypted PDF files, or as web pages. You can easily distribute reports by email, FTP, file server, and printer.

View Datasheet

ODBC Connector

Use other third party reporting options like Spotfire, Tableau, Dream Reports, and more by making SQL queries from the data tables of the Enterprise Historian with Canary’s ODBC connection.

aggregated data
play_circle_filled

Connecting spotfire to the historian using the ODBC connector.

Watch Video

Question/Answer

keyboard_arrow_rightkeyboard_arrow_downWhat is processed data?

Processed data is calculated using an aggregate and time interval. A common use of processed data is to get the average values of the raw data over specified time intervals.

keyboard_arrow_rightkeyboard_arrow_downWhat are aggregates?

Aggregates are the calculation algorithms used when retrieving processed data. Some aggregates are TimeAverage, Minimum, Maximum, Total, Start, PercentGood, Count, and more.

keyboard_arrow_rightkeyboard_arrow_downCan I access the database using SQL queries?

Yes, you can use the ODBC Connector to make SQL queries into the database.

keyboard_arrow_rightkeyboard_arrow_downCan I schedule reports?

Yes, XL Reporter allows for scheduled reports via email, FTP, file server, or printer.

keyboard_arrow_rightkeyboard_arrow_downCan I connect the Canary database to other reporting tools?

Indeed, you can. Choose between our ODBC Connector, HDA Connector, or our API.

Affordable Pricing

View Pricing
arrow_upward