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 Reports module.
  2. On the Reports Overview page, click Reports again 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 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 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

                Zoho SalesIQ Resources



                    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

                                                        • 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 ...
                                                        • 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 ...
                                                        • Predefined and Custom Ticket List Views

                                                          List Views are used to group records based on a defined set of criteria. For example, you can view a list of Open tickets that are unassigned, a view for tickets that are overdue, or a view for tickets that are created in the last week. This way ...
                                                        • Creating Custom Reports in Zoho Desk

                                                          You can create new module-specific reports linking some of the other cross-functional modules. For example, you can create a report in the tickets module linking other modules such as Contacts, Accounts, Time Entry, and others. Types of Report ...
                                                        • Get Advanced Reports with Zoho Analytics Integration

                                                          The Reports module of Zoho Desk allows you to generate reports to know most of the important metrics in your help desk. Even though they address the requirements of a majority of businesses, there is always a need for some advanced customization ...

                                                        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