What's my plan?
All Suites Professional, Enterprise, or Enterprise Plus
Support with Explore Professional or Enterprise
In this Explore recipe, you'll learn how to create a report that shows your customer satisfaction rating by agent.

What you'll need

Skill level: Moderate

Time Required: 20 minutes

  • Zendesk Explore Professional or Enterprise
  • Editor or Admin permissions (see Giving agents access to Explore)
  • Ticket data in Zendesk Support

Creating the report

    To create the report

    1. In Zendesk Explore, click the reports () icon
    2. In the Reports library, click New report
    3. On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens
    4. In the Metrics panel, click Add
    5. From the list of metrics, choose Tickets > Solved tickets, then click Apply
    6. From the list of metrics, choose Customer satisfaction > % Satisfaction rated and Customer satisfaction > % Satisfaction score, then click Apply
    7. In the Columns panel, click Add
    8. From the list of attributes, choose Assignee > Assignee name, then click Apply
    9. From the Visualization type () menu, click Column
    10. Click the % Satisfaction rated metric, change the axis to Dual, then click Apply
    11. Click the % Satisfaction score metric, change the axis to Dual, then click Apply
    12. From the Chart configuration () menu, click Secondary axes
    13. On the Secondary axes page, change Type of secondary series to Column
    14. Under SUM(% Satisfaction rated) set the Max value to 1
    15. Select Hide title under each metric, and hide the axis under one of the metrics
    16. From the Chart configuration () menu, click Display format
    17. On the Display format page, change the display format for % Satisfaction rated and % Satisfaction score to %
    18. From the Chart configuration () menu, click Displayed values
    19. On the Displayed values page, change Show value to Show
    20. On the Chart page, unselect Stacked
      Chart.png

    The report is complete. See the screenshot below for an example of the finished result with one agent selected.

    Next steps

    Below are some examples of how you can enhance this report.

    • Add a filter for Ticket solved - Date, then edit the date range to the period for which you want information. See Editing dates and date ranges
    • To filter the top agents by ticket solves, you can use a top/bottom filter, see this article: Creating a top/bottom filter
    • If you want to show results only where the number of satisfaction surveys offered was greater than a value, you can use a metric filter, see this article: Selecting the metric result range

    Powered by Zendesk