Creating Summary Views | Zoho Analytics On-Premise

Creating a summary view


A Summary View allows you to dynamically summarize large amounts of data for easy analysis and visualization. You can transform data in table(s) into interactive and meaningful summaries easily, by using the intuitive drag and drop interface of Zoho Analytics. Please note that only Server Administrators and Managers can create new reports. To know more about the user roles in Zoho Analytics, click here.  

Creating a Summary View

Follow the below steps to create a summary view:

  • Login to Zoho Analytics and open the Workspace in which you wish to create a summary view.
  • Click the New icon and select New Report.

 

  • Select Summary View in the Create New Report window that opens.

 

  • Select the base table on which you wish to create the summary view.

 

  • Click OK.

Alternatively, you can also create a new summary view by opening the corresponding table on which you want to create the view and then clicking New > New Summary View option in the toolbar.

 

The summary view designer looks as shown below.

 

On the left hand side is the Column pane, listing all the columns available in the table. On the right hand side is the Design Area with shelves to drop the columns and a Preview area below to preview the report that is created.

You should drag and drop the required columns listed in the column list pane into the respective shelves in order to create a summary view. You can also select the check box adjacent to each column listed to auto place the columns into the appropriate shelves.

  • Group by shelf: The columns dropped in this shelf are grouped based on the unique values present in the column
  • The Summarize shelf: The data in the columns dropped in this shelf will be summarized based on the summary functions selected

Example: Let us see how to create a simple summary view to summarize the sales of the top 10 products based on the profit obtained. We will be creating this Summary View on the Sales Table (shown below).

 

The following is the Summary View that we are going to create.

 

Drag and drop the following columns in the summary tab:

  • Group by shelf - Product Category, Product
  • Summarize shelf - Sales, Profit

 

 

The following tables list all the functions along with the description of their functionality that are applicable for Group by shelf.

String Data Type
Function Description
Actual Values All the distinct values in the column will be listed.

Date Data Type - Actual values
Function Description
Year Returns all distinct year values present in the column. E.g.,2007, 2010
Quarter & Year Returns all distinct quarter values present in the column. E.g., Q1 2010
Month & Year Returns all distinct month values present in the column. E.g., March 2010
Week & Year Returns all distinct week values present in the column. E.g; W1 2010
Full Year Returns all distinct dates present in the column. E.g., 1/1/2011
Date & Time Returns all distinct date and time present in the column. E.g. 01/12/2010 00:10:07 hrs.

Date Data Type - Seasonal Value
Function Description
Quarter Identifies seasonal trends based on quarter across all years. E.g., Q1, Q2.
Month Identifies seasonal trends based on months across all years. E.g., January, February.
Week Identifies seasonal trends based on weeks across all years. E.g., Week 1, Week 2.
Week Day Identifies seasonal trends based on week day across all years. E.g., Sunday, Monday.
Day of Month Identifies seasonal trends based on day of month across all dates. E.g., 1 to 31.
Hour of Day Identifies trend across hours in a day. E.g., 0 to 23hrs.

Numeric and Currency Data Types
Function Description
Dimension Treats the values in the column as a textual (categorical/dimensional) value. Returns each distinct value present as a text value.
Range Groups the entire range of numeric values present in the column into multiple ranges. E.g., 0 to 100, 101 to 250 etc.,

You can apply functions such as sum, max, min, count etc on the columns dropped in the summarize shelf. The following tables list all the functions along with the description of their functionality that are applicable for Summarize shelf.

In the above example we have dropped the Sales and Profit column and selected Sum.

String Data Type
Function Description
Count Returns the number of values in the column.
Distinct Count Returns the number of distinct values in the column.

Date Data Types
Function Description
Count Returns the number of date values in the column.
Distinct Count Returns the number of distinct date values in the column.

Numeric and Currency Data Types
Function Description
Sum Returns the sum of all the values in the column.
Maximum [Max] Returns the maximum value in the column.
Minimum [Min] Returns the minimum value in the column.
Average [Avg] Returns Arithmetic mean of all the values in the specified column.
Standard Deviation Returns the standard deviation of the column.
Variance Returns the variance of the column.
Count Returns a count of number of values in the column.
Distinct Count Returns the number of distinct values in the column.

Applying Filters

Summary View offers powerful filtering capabilities that enables you to view only the required data. Zoho Analytics allows you to filter data based on individual values, numeric ranges, date ranges, top 10, bottom 10 etc,. It also allows you to apply multiple filters (based on multiple columns) on your report.

The filtering option discussed in this topic can be applied only when you are designing a summary view in Design Mode and not in View mode. (Refer Filters section in charts to learn about filters in detail)

To apply filters,

  • Click the Filters tab next to the Summary tab.
  • Drag and drop the column that you wish to add as a filter.
  • Select the values that you wish to filter. You choose to either include or exclude the data in the Include/Exclude Items shelf.
  • Click here to Generate Summary.

Continuing with the example - we will be filtering the report based on profit. Drop the Profit column and select Top 10 by Product.

 

User Filters

Summary View provides dynamic filtering capabilities in View Mode called User Filters. This enables the users who view the report to apply filters dynamically.

To create user filters,

Drag and drop the columns in the User Filters tab which is next to the Filters tab. (Refer User Filters section in Charts to know more)

Continuing with the example - Drop the Date Column in the User Filters tab to enable users to filter the report dynamically based on the Date of Sale.

 

The final report along with the User Filters.

 


    Access your files securely from anywhere

      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

                                                                                                              • Summary View

                                                                                                                Summary View, as the name indicates, is a report type that enables you to view your summarized data in tabular formats. This report type is extremely useful when you need to analyze huge amount of data with logical grouping and appropriate ...
                                                                                                              • Creating a new tabular view

                                                                                                                With Zoho Analytics' intuitive drag-and-drop report builder, you can easily create a tabular view within minutes. This document explains the various steps involved in creating the required tabular view. Creating a tabular view Follow the steps below ...
                                                                                                              • Creating Reports

                                                                                                                Zoho Analytics offers a wide variety of reporting options such as Charts, Pivot tables, Summary views and Tabular views. This enables you to easily analyze your data and derive great insights. The intuitive drag and drop based designer of Zoho ...
                                                                                                              • Creating a chart

                                                                                                                Zoho Analytics provides an easy to use drag and drop interface to create charts fast & easy. You can create various types of charts including Bar, Line, Pie,Stacked, Scatter, Area, Combination, Funnel, Web and 3D charts by simply dragging and ...
                                                                                                              • Creating a Dashboard

                                                                                                                Dashboard allows you to combine multiple reports in a single page for a quick overview. Zoho Analytics provides a flexible m x n layout that allows you to organize the dashboard in any way as required. With this, you can easily create a visually rich ...
                                                                                                                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