Working with Tabular View | Zoho Analytics On-Premise

Working with tabular view


Zoho Analytics provides various options to sort, filter, format, and freeze the columns in a tabular view.

Sorting a tabular view

By default, Zoho Analytics sorts the data in ascending order based on the data columns in the Group by block shelf. You can also sort the data columns per your requirements.

Follow the steps below to sort a tabular view,

  • Open the required tabular view in View mode.

  • Right-click the required column and click Sort. You can also click the Sort option from the toolbar. The following options are available:

    • Sort Ascending: This option allows you to sort the column's data in ascending order.

    • Sort Descending: This option allows you to sort the column's data in descending order.

    • Remove Sorting: Use this option to remove the applied sorting function.

  • You can also sort the data columns easily, by clicking the arrow icon that appears on mouse over the column header. A down arrow indicates that the column is sorted in ascending order, while an up arrow implies that the column is sorted in descending order.

The sort option in tabular view is similar to the sort option present in tables. Click here to learn more about sorting.

Applying dynamic filters

Zoho Analytics allows you to dynamically filter the tabular view to display the required data. Follow the steps below to do this.

  1. Open the required tabular view, and click the Filter button in the toolbar. The filter pane is displayed with the filter options for each column. These options will vary based on the data type of the column.

  2. Choose the required filter condition from the dropdown, provide the filter value and click Apply.

    You can also apply filters to multiple columns.

  3. On adding the required filters, click the Save (New*) button.

To edit or delete the existing filters,

  • Click the Filter drop-down, navigate to the required filter, and click the Edit or Delete icon.

Zoho Analytics also allows you to include or exclude specific values from a tabular view. To do this, right-click on the required data cell, and click the Filter including this value or the Filter excluding this value option to display data as required.

Note: The dynamic filters are not visible to the shared users.

Freezing a column

Zoho Analytics allows you to pin columns, i.e., ensure the columns are visible when you move horizontally across the report. These pinned columns are displayed at the beginning of the tabular view, one after the other.

  • To freeze a column, select the required column and click More > Freeze Column from the toolbar. You can also right-click the column and select the Freeze Column option.

  • To unfreeze the column, click the Unfreeze (pin) icon on the top right corner of the column header.

Sharing a tabular view

Zoho Analytics provides various sharing options that facilitate ease of collaboration. You can share a view, and provide various permissions and filters for the shared view.

Follow the steps below to share a tabular view.

  1. Open the required tabular view and click Share > Share this View in the toolbar.

  2. In the dialog that opens, provide the required inputs and click the Share button. Refer to the Sharing and Collaboration page to know about sharing a tabular view.

Note: The share option will be enabled only for users who were provided with the appropriate permissions while sharing the tabular view.

Publishing a tabular view

Zoho Analytics allows you to publish the tabular view into your websites/web pages, or as easy-to-access URLs. You can also specify access privileges for the users who access the published view. Refer to the Publishing Options page to know about publishing a tabular view.

Exporting a tabular view

Zoho Analytics allows you to export the tabular view into various file formats like CSV, PDF, XLS, and HTML. Follow the steps below to do this:

  1. Open the required tabular view and click the Export icon in the toolbar.

  2. The following export options are available:

    • As CSV: This option allows you to export the tabular view as a Comma Separated Value (CSV) file.

    • As Excel: This option allows you to export the tabular view as an excel file.

    • As PDF: This option allows you to export the tabular view in a Portable Document Format (PDF) file format.

    • As HTML: This option allows you to export the tabular view in an HTML file format.

    • As Template: This option allows you to export the tabular view as a template file that can be used to recreate this tabular view across other workspaces. Click here to learn more about importing views from templates.

  3. In the Export As page that opens, provide the required specifications, and click Export. Click here to learn more about exporting a tabular view.


    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

                                                                                                        • Tabular Views

                                                                                                          Zoho Analytics offers a simple and efficient way to summarize, structure, and group large volumes of data in the form of Tabular views. These views are similar to a report or a spreadsheet and allow users to easily sort, filter, and customize the ...
                                                                                                        • Customizing a tabular view

                                                                                                          Zoho Analytics offers a wide range of customization options that enable you to modify the format, sort, apply themes, and customize the tabular view as needed. Note: Ensure you save the tabular view report to access the various customization options. ...
                                                                                                        • 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 ...
                                                                                                        • 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 Tables

                                                                                                          Zoho Analytics offers a range of interactive options to work with a table. Some of the options include Filter, Sort, Format, Find and Replace values, Freeze and Show/Hide Columns. Zoho Analytics also allows to Export, Share and Publish a table. Note: ...
                                                                                                          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