Static Reports - Zoho Desk Knowledgebase

Working with Static Reports

Static Reports are tabular reports that consist of an ordered set of fields in columns, with each row representing a ticket. As its name suggests it is generated for certain predefined filter parameters, that cannot be changed. A report of tickets that violated SLA targets, for example, is a static report. Zoho Desk includes two static reports that you can run right out of the box. They are:
  • Violated Tickets
  • Reopened Tickets

Violated Tickets
The Violated Tickets report helps you better understand your SLA violations by listing the tickets that breached an SLA metric's target time. You can also drill-in to view underlying tickets in each channel by selecting a Channel name, or you can view tickets handled by each owner by selecting the Agent name. The following fields are available when viewing the Violated Tickets report:

Field
Description
Ticket ID
The unique ID assigned to the ticket
Subject
The subject of the ticket
Ticket Owner
The current owner of the ticket
SLA Name
The name of the SLA policy that the ticket is measured against
Violated Time
The time at which the SLA metric's target time was violated
Owner During Violation
The ticket's owner at the time of SLA violation
Violation Type
The violation type (First Response Violation or Resolution Violation) specific to the SLA
Priority
The current priority of the ticket
Response Due Date
The next date and time at which the ticket must be responded
Resolution Due Date
The next date and time at which the ticket must be resolved
Channel
The channel the ticket was created from
Status
The current status of the ticket

Reopened Tickets
There could be various reasons as to why a ticket might be reopened by an end user. But it is important to see if your agents are closing tickets too early when the end user is not satisfied yet with the resolution.

The Reopened Tickets report helps you better understand this by listing the tickets that have been solved at least once and then reopened. You can also drill-in to view underlying tickets in each channel by selecting a Channel name, or you can view tickets handled by each owner by selecting the Agent name. The following fields are available when viewing the Reopened Tickets report:

Field
Description
Ticket ID
The unique ID assigned to the ticket
Subject
The subject of the ticket
Ticket Owner
The current owner of the ticket
Owner During Reopen
  The ticket's owner at the time of reopening
Created Time
  The time at which the ticket was created
Reopen Time
  The time at which the ticket was reopened
Channel
  The channel the ticket was created from
Status
  The current status of the ticket

Accessing Static Reports
The Static Reports can be accessed from under the Reports tab in your help desk account.
To access the reports:
  1. Click the Analytics module.
  2. On the Analytics Overview page, click Reports from the left panel.
  3. On the Reports Home page, scroll down to access the Static Reports section at the bottom of the page.

Defining Time Frames
By default, static reports will display tickets that were violated or reopened during the last 7 days. However, you can customize the time frame to locate specific tickets or to identify trends in the number of tickets over time.

There are nine predefined time frames that you can use for all static reports:
  • Last 24 hours
  • Today
  • Yesterday
  • Last 7 days (default for all static reports)
  • Last 30 days
  • Current week
  • Last week
  • Current month
  • Last month
    • Custom - Select a start and end date

To define the time frame:
  1. Select a static report.
  2. On the Report Details page, select the Last 7 days filter in the upper-right area.
  3. In the drop-down menu, do one of these:
    • Select a predefined time frame from the drop-down list.
    • Select Custom and then specify a custom date or range of dates.
  4. The report data will be updated to reflect the changes.

Grouping Report Data
Zoho Desk supports grouping of tickets based on specific fields in a static report. Tickets with the same value in the selected column(s) are grouped together and the count of tickets will appear alongside the grouped value. For example, in the Violated Tickets report you can group violated tickets by the SLA name.
The following are the predefined values by which you can group the tickets:
  • None (default for all static reports)
  • Date
  • Channel
  • Agent
  • Ticket
  • SLA (only for Violated Tickets report)

To group report data:
  1. Select a static report.
  2. On the Report Details page, click the More icon (  ) in the upper-right corner of the page.
  3. In the Group by section, select a field to group by.
  4. Columns you group by will display first in the static report.

Note:
  • You cannot group reports data by more than one field.

Exporting Report Data
The Export feature enables you to export your report data anytime in the formats - Excel (grid format), CSV, and PDFPlease keep in mind that you can export a maximum of 2000 records per instance.

To export report data:
  1. Select a static report.
  2. On the Report Details page, click the More icon (  ) in the upper-right corner of the page.
  3. Hover your mouse pointer over the Export option and then select the required export format.
  4. The report will be instantly exported and downloaded into your default folder in the chosen format.

    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

                                                                                                              • Using Predefined Reports in Zoho Desk

                                                                                                                Zoho Desk provides a collection of predefined reports that are designed to offer instant, out-of-the-box customer support insights. Each report provides access to relevant data required for various purposes. The reports can be further tailored to ...
                                                                                                              • Report Columns for Tickets - Explained

                                                                                                                When you create a report on the tickets module, you can choose what columns to include. For example, you need to select the field names from the Available Columns list box whose data will be displayed on the report. Besides the field names, you can ...
                                                                                                              • FAQs: Working on Tickets

                                                                                                                What are Tickets Tabs in Zoho Desk? Tickets Tabs in Zoho Desk are designed to organize and provide contextual information about support tickets within the help desk system. These tabs enable users to connect tickets with other standard modules of ...
                                                                                                              • Understanding the Agent Performance report

                                                                                                                One of the most useful reports for monitoring the day-to-day performance of your agents is the Agent Performance report. This report offers detailed statistics on several agent performance metrics and can be configured to show data for one or more ...
                                                                                                              • Understanding Agent Availability Report

                                                                                                                It's important for an organisation to know when their support agents log in and log out of work. The Agent Availability report is one of the Static Reports that helps admins track the active working hours of each agent and allows them to regulate the ...
                                                                                                                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