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.

    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







                                                                                            You are currently viewing the help articles of Sprints 1.0. If you are a user of 2.0, please refer here.

                                                                                            You are currently viewing the help articles of Sprints 2.0. If you are a user of 1.0, please refer here.



                                                                                                  • 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 ...
                                                                                                  • 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 ...
                                                                                                  • FAQs: Working on Tickets

                                                                                                    What are Ticket Tabs? Ticket tabs allow you to link tickets to the other standard modules in your help desk. These tabs provide contextual information about a ticket such as ticket activity, pending tasks, supportive files, resolutions and the like. ...
                                                                                                    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