Customizing a Summary View

Customizing a Summary View

Customizing a Summary View

When designing a Summary View, Zoho Analytics offers a wide range of options to customize the view to suit your needs. In this section we will discuss about various options provided by Zoho Analytics to customize a Summary View that you create.

Customizing the Appearance of a Summary View

Zoho Analytics allows you to customize the appearance of the Summary View (like adding description, hiding row numbers etc.).

To customize the appearance of the Summary View, follow the steps given below:

  • Open the Summary View you would like to customize.
  • Select Settings option in the toolbar. This will open the Settings page. You will notice that this page contains three tabs - GeneralFormat, and Display.

Title, Description, and Show Missing Values

Zoho Analytics provides options to modify the title and description in the General tab of your Summary View.

  • TitleYou can edit the title of your Summary View from here. This field is mandatory.
  • Description: You can change the description of your Summary View from here. This field is optional.

Format Tab

Zoho Analytics allows you to change the display labels and display format of the data columns used in your Summary View as required.

You can edit the following details from the Format tab:

  • Label: You can edit the labels of the columns in your Summary View.
  • Format: You can change the format of the data displayed in your Summary View. The options in the Format dialog will vary depending on the data type of the column. These options will be similar to that of the table column formatting options in Tables. For more details refer here.

Display

Zoho Analytics allows you to customize the layout of your Summary View.

Under the Display section, you can customize the following options:

    • Hide row numbers: Select this checkbox if you do not wish to display the index number for the rows. By default, this will not be selected.
    • Wrap text in Column Headings: This wraps the text in a column header to next line in case the column headers are lengthy.
    • Repeat group label value in each row: Select this option in case you wish to repeat the group label for each row. (Check the snapshot below)

  

  • Set default column width to: You can uniformly resize the columns by selecting this checkbox and then specify the required width in pixel in the provided field. You could also choose to apply this new width to the already resized columns using the Apply to manually resized columns checkbox.
  •  Display 'Unknown' value as: Null or empty value present in the underlying data of the Summary View will be displayed as -No Value- by default. You can specify an alternate value that could be displayed instead of this in the Display 'Unknown' value as field.

Renaming

Zoho Analytics provides option to rename columns. 

To rename a column, follow the given steps:

  • Open the Summary View in Edit Mode.
  • Right click the column header and then select Rename Column.

You can also rename the column by clicking the Edit icon in the column header

Sorting

To sort a column:

  • Right click the column header. 
  • Select one of the following sorting options
    • Sort Ascending - Sorts text data in ascending alphabetical order (A to Z), numbers from smallest to largest (0-9), and dates from oldest to latest.
    • Sort Descending - Sorts text data in descending alphabetical order (Z to A), numbers from largest to smallest (9-0), and dates from latest to oldest.
    • Remove Sorting - Clears the applied sorting. 

Freezing Columns

In a Summary view, you can freeze one or more columns to keep them visible while scrolling horizontally. This is especially helpful when your report includes several metrics or calculated columns, and you want to keep key identifiers in view.

To freeze a column,

  1. Right-click the column header you want to keep visible.
  2. Select Freeze Column from the list.

A pin icon will appear near the column header, indicating that the column is frozen.
The frozen columns will stay fixed on the left side of the table when you scroll horizontally.

To unfreeze a column,
You can unfreeze a column in either of these ways:

  • Click the pin icon in the column header.
  • Right-click the frozen column and select Unfreeze Column.

When you unfreeze all columns in the frozen section, the Summary view returns to its normal scrolling behavior.

Notes

Note:

  • The freeze behavior depends on the screen size. If a frozen column does not fit within the current screen width, it will be automatically unfrozen.
  • The freeze limit is based on the number of columns frozen, not on specific column instances.

Conditional Formatting

Conditional formatting feature allows you to visually highlight data cells in a Summary View with different styles based on matching conditions. You have to specify the required conditions/criteria for formatting. The condition that matches first with the data cell will be applied.

To apply conditional formatting:

  • Open the Summary View for which you want to apply Conditional Formatting.  
  • Right click on any one of the cells in the data series for which you want to apply conditional formatting.  
  • In the menu, click Conditional Formatting.
  • The Conditional Formatting dialog opens with options for specifying the conditions and selecting colors for font and background. 

  • Click the drop down arrow under Condition header and select the type of the condition that you want to apply.
  • Type the matching value that you want to use for the condition in the Value text box.
  • Select the required colors for the font and background.
  • You can also insert texts and icons using the Additional Formatting Options dialog to highlight your condition. Click the  icon to add text and icons.
  • You can add any number of conditions using +Add Condition link.
  • Conditions specified will be evaluated from top to bottom and the corresponding formatting options that matches first will be applied on the data cell that meets the condition.   
  • Click OK after you have added all the conditions.

You can also view and modify all the conditional formats applied over the Summary View in Conditional Format tab in Settings section.   



        Create. Review. Publish.

        Write, edit, collaborate on, and publish documents to different content management platforms.

        Get Started Now


          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







                                Quick LinksWorkflow AutomationData Collection
                                Web FormsEnterpriseOnline Data Collection Tool
                                Embeddable FormsBankingBegin Data Collection
                                Interactive FormsWorkplaceData Collection App
                                CRM FormsCustomer ServiceAccessible Forms
                                Digital FormsMarketingForms for Small Business
                                HTML FormsEducationForms for Enterprise
                                Contact FormsE-commerceForms for any business
                                Lead Generation FormsHealthcareForms for Startups
                                Wordpress FormsCustomer onboardingForms for Small Business
                                No Code FormsConstructionRSVP tool for holidays
                                Free FormsTravelFeatures for Order Forms
                                Prefill FormsNon-Profit

                                Intake FormsLegal
                                Mobile App
                                Form DesignerHR
                                Mobile Forms
                                Card FormsFoodOffline Forms
                                Assign FormsPhotographyMobile Forms Features
                                Translate FormsReal EstateKiosk in Mobile Forms
                                Electronic Forms
                                Drag & drop form builder

                                Notification Emails for FormsAlternativesSecurity & Compliance
                                Holiday FormsGoogle Forms alternative GDPR
                                Form to PDFJotform alternativeHIPAA Forms
                                Email FormsFormstack alternativeEncrypted Forms

                                Wufoo alternativeSecure Forms

                                TypeformWCAG


                                    All-in-one knowledge management and training platform for your employees and customers.

                                              Create. Review. Publish.

                                              Write, edit, collaborate on, and publish documents to different content management platforms.

                                              Get Started Now




                                                                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


                                                                      • Desk Community Learning Series


                                                                      • Digest


                                                                      • Functions


                                                                      • Meetups


                                                                      • Kbase


                                                                      • Resources


                                                                      • Glossary


                                                                      • Desk Marketplace


                                                                      • MVP Corner


                                                                      • Word of the Day


                                                                      • Ask the Experts


                                                                        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 Demo

                                                                                                          Get a personalized demo or POC

                                                                                                          REGISTER NOW


                                                                                                            Design. Discuss. Deliver.

                                                                                                            Create visually engaging stories with Zoho Show.

                                                                                                            Get Started Now








                                                                                                                                • Related Articles

                                                                                                                                • Introduction to 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 ...
                                                                                                                                • Working with a Summary View

                                                                                                                                  Customizing the Summary View View Underlying data Exporting Sharing Publishing View Underlying data Zoho Analytics enables you to view the data that makes up the Summary View. You can click on any cell in the Summary View to view its underlying ...
                                                                                                                                • Tabular View

                                                                                                                                  A Tabular View as the name implies is a simple, yet powerful table-like (or spreadsheet-like) report that you can create over your data tables in Zoho Analytics. Though lightweight, the Tabular View is one of the powerful reporting options offered by ...
                                                                                                                                • Creating A Summary View

                                                                                                                                  Creating A Summary View Creating a Summary view Applying Filters Creating User Filters 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 ...
                                                                                                                                • Customizing a Pivot Table

                                                                                                                                  When designing a Pivot Table, Zoho Analytics offers a wide range of options to customize it and improve the overall appearance in different ways. In this section, we will discuss about various options provided by Zoho Analytics to customize the Pivot ...
                                                                                                                                  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