Understanding Reports

Understanding Reports


Zoho IOT Reports helps you track the behavior and insights of connected
devices and assets in IoT networks based on data collected from them. These Reports can be generated in multiple formats using various chart and table options to get the desired output.
 
Zoho IOT offers the following four different types of reports: Instance Comparison Report, Aggregated Chart Report, Summary Table Report, and Matrix Table Report.
 

  
Let's understand each of these reports in detail.

 
Instance Comparison Report   

The Instance Comparison Report allows you to analyze datapoint values from different instances over a specified time period.
 
This report is constructed by selecting one or more instances, and the datapoints for each instance for generating a detailed trend report over a selected time period, such as Last Hour, This Month, or This Year. The report can be viewed based on raw or aggregated data.
 
The Instance Comparison Report is used in various scenarios to analyze and visualize data for better insights into the performance of managed entities in the setup. Some common situations where a Instance Comparison report is utilized are: Trend Analysis, Performance Reports, Comparative study, etc.,
  1. Real-time/Historical Data Analysis: To review and analyze available data over a specified period. This helps in identifying trends, patterns, and anomalies in energy usage.

  2. Performance Monitoring: To monitor the performance of various managed entities in the environment by tracking various configured metrics.

  3. Comparative Analysis: To compare various metrics across different time periods, locations, for managed entities. This can help in identifying any process defects and areas for improvement.
 
 

 
Image: Sample Instance Comparison Report

Sample Report : In the above sample report, Today's average temperature in two different rooms is grouped and displayed every hour in line chart format. 

 
Aggregated Chart Report 

The Aggregated Chart Report helps you view the summary of values of all managed entities associated to the selected model.
 
This report is constructed by selecting a model, and all instances associated with the selected model are considered for a given time period, such as hourly, monthly, or yearly.
  1. Aggregated Chart Reports is used in scenarios such as IIoT are crucial for maximizing the value of data collected from various managed entities. The aggregation of values enable organizations to gain deeper insights and improve operational efficiency of the entities. Some common scenarios where an Aggregated report is utilized are: Deeper Trend Analysis, Performance Reports, Operational Efficiency, etc.,

  2. Trend Analysis: By aggregating data over time, these reports help in identifying trends and patterns, which can be critical for predicting future performance, maintenance needs, and potential issues.

  3. Performance Monitoring: Aggregated reports facilitate continuous monitoring of key performance indicators (KPIs). This enables quick identification of deviations or even crucial faults in advance.

  4. Operational Efficiency: By analyzing aggregated data, organizations can identify inefficiencies and aim improvements leading to increased efficiency and productivity.

 

 
Image: Sample Aggregated Chart Report
 
Sample Report : In the above sample report, the energy consumed by different energy meters for the day is displayed in column chart format.

Summary Table Report 

The Summary Table report helps you to view a tabular format of datapoint values from managed entities.
 
This report is constructed by selecting the managed entities to display the selected field and  datapoint values for a selected timeline, such as hourly, monthly, or yearly.
 
Summary Table reports are recommended when structured and systematic data presentation is desired. This format makes it easier to analyze and interpret even complicated data. The key features are provided below. They eventually help in performance and trend analysis leading to improved efficiency.
  1. Clear Presentation: Tabulated data presents information in a clear and concise manner, making it easier to understand and analyze.

  2. Sorting and Filtering: Data can be sorted and filtered based on various metrics, allowing for targeted analysis.

  3. Quick Reference: Tables provide a quick reference to key data points, facilitating faster decision-making.


 
Image: Sample Summary Table Report
 
Sample Report : In the above sample report, the avg. temperature, avg. humidity, avg. CO2 level, and avg. TVOC  in different rooms within a parent location is displayed for every hour in tabular format.

Matrix Table Report  

The Matrix Table report helps you to view a tabular and matrix format of datapoint values from across different managed entities in the same report.
 
This report is constructed by selecting the managed entities to display the selected datapoint values across managed entities for a selected timeline, such as hourly, monthly, or yearly.
 
Matrix Table reports are recommended when datapoint values of multiple managed entities against multiple metrics need to be displayed. This format makes it easier to analyze and interpret even complicated data. Matrix reports offer several advantages, particularly in presentation and data analysis. Here are some key benefits:
  1. Cross-Tabulation: Matrix reports allow for the comparison of data across multiple managed entities and multiple metrics, enabling cross-tabulation and multi-faceted analysis.

  2. Comprehensive View: By displaying data in a grid format, they provide a comprehensive view of relationships between different metrics.

  3. Quick Reference: Tables provide a quick reference to correlations and anomalies within the data.

 

 
Image: Sample Matrix Table Report 
 
Sample Report : In the above sample report, the avg. temperature, avg. humidity, avg. CO2 level, and avg. TVOC  in different rooms within a parent location is displayed for every hour in tabular format.
 

Grouping Types in Reports 

Time Property Grouping

In Time grouping, data is retrieved from the database and organized based on time during the report generation process.

Instance Property Grouping

In Instance Property grouping, data is retrieved from the database and organized based on any managed entity property or Located At property value during the report generation process.

 
Time and Instance Property Grouping 

In the Time and Instance Property grouping, data is organized based on both a managed entity property and time for the selected module.
 

 
Multiple matrix/table formats can be used in the case of time and instance property grouping. As different values are mapped for a managed entity, the matrix format is considered.
 
Time and Instance Table Report



The time and instance matrix table report is constructed with managed entity data for selected time and selected managed entity name in the left of the table. For example.
 
Time vs Instance Matrix Report
 


The time vs instance matrix table report is constructed with managed entity data for selected time displayed on the left against the selected managed entity name at the top of the table. For example.
 
Instance vs Time Matrix Report



The instance vs time matrix table report is constructed with the selected managed entity name on the name and the time displayed at the top of the table. For example.
 

Report Options 

Grouping Reports 

During report creation, there is provision to create a group to segregate and store the report, if the group is not present already. Grouping feature is useful especially when there are numerous reports in the application. Below are some examples of grouping.
  1. Group reports that display the performance of devices under Energy Reports.
  2. Group reports of devices in a particular location based on the location name. e.g. Data Center.
  3. Group reports about specific types of devices. e.g. all Air Quality related reports as IAQ Reports, etc.
 

 

Setting as Favorite

All reports can be invoked from the expandable tree nodes in the left pane of the application. However, critical or commonly accessed reports can be marked as Favorite to stand out from the other normal reports.
 

 

 
Default Landing Report 

The anchor symbol is selected to configure the landing report when Reports is accessed in the application.
 

Scheduling Reports   

 Scheduled Reports are configured to send out certain reports to selected recipients via email at specific dates and times on a recurring basis. This ensures that supervisors and decision makers in IoT setups receive the latest data and insights regularly without manual intervention. Refer to the Working with Scheduled Reports document for step-by-step procedure.

See Also

    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      Redefine the way you work
      with Zoho Workplace

        Zoho DataPrep Personalized Demo

        If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

        Zoho CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION











                                        You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                            Manage your brands on social media

                                              Zoho Desk Resources

                                              • Desk Community Learning Series


                                              • Digest


                                              • Functions


                                              • Meetups


                                              • Kbase


                                              • Resources


                                              • Glossary


                                              • Desk Marketplace


                                              • MVP Corner


                                              • Word of the Day


                                                Zoho Marketing Automation

                                                  Zoho Sheet Resources

                                                   

                                                      Zoho Forms Resources


                                                        Secure your business
                                                        communication with Zoho Mail


                                                        Mail on the move with
                                                        Zoho Mail mobile application

                                                          Stay on top of your schedule
                                                          at all times


                                                          Carry your calendar with you
                                                          Anytime, anywhere




                                                                Zoho Sign Resources

                                                                  Sign, Paperless!

                                                                  Sign and send business documents on the go!

                                                                  Get Started Now




                                                                          Zoho TeamInbox Resources



                                                                                  Zoho DataPrep Resources



                                                                                    Zoho DataPrep Demo

                                                                                    Get a personalized demo or POC

                                                                                    REGISTER NOW


                                                                                      Design. Discuss. Deliver.

                                                                                      Create visually engaging stories with Zoho Show.

                                                                                      Get Started Now









                                                                                                          • Related Articles

                                                                                                          • Understanding Locations

                                                                                                            Introduction to Location In Zoho IOT, a location represents a physical place with multiple devices and assets located under it. Each location can function as either a parent location having one or more child locations, and a child location can ...
                                                                                                          • Understanding Widgets

                                                                                                            Widgets are the building blocks of a dashboard. They display vital statistics in intuitive formats. In Zoho IOT Application, you can create widgets of type cards, charts, dials, image, tables, calendars, commands, maps, timeline, and image layout. ...
                                                                                                          • Scheduling Reports

                                                                                                            The Scheduled Reports feature enables you to email IoT reports to selected recipients on a specified date and time, either once or on a recurring basis. These reports are sent as email attachments, providing a robust method for keeping stakeholders ...
                                                                                                          • Understanding Table Widgets

                                                                                                            The Table Widget, also referred to as the list view widget, is used to display the details of the selected module/model, assets, policies, alarms, etc. The two different table formats available are: Custom View Table Reports Table Custom View Table ...
                                                                                                          • Understanding Data Slicing Rules

                                                                                                            Data Slicing rules can be defined to dictate what data and records are accessible for each user in the Zoho IOT application. Data Slicing is highly useful in building dashboards and generating reports. Consider a dashboard designed to monitor an ...
                                                                                                            Wherever you are is as good as
                                                                                                            your workplace

                                                                                                              Resources

                                                                                                              Videos

                                                                                                              Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                              eBooks

                                                                                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                              Webinars

                                                                                                              Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                              CRM Tips

                                                                                                              Make the most of Zoho CRM with these useful tips.



                                                                                                                Zoho Show Resources