Skill level: Easy

Time Required: 15 minutes

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

Creating the Report

1. In Explore, navigate to the Queries library by clicking the reports () icon.
2. Click New report.
3. On the Choose a dataset page, click Support > Tickets > Support: Tickets, then click New report. The report builder will open for you.

Create a renamed set

1. From the configuration menu, choose Calculations > Renamed Set.
2. Add a name = Satisfaction ratings - visual.
3. Set the computed from field to > Ticket Satisfaction rating.
4. Update the field values - See example below:
5. Click Save.

You can copy & paste emojis straight into to text box for the value box. We recommend using our favourite emoji site here to copy all your favourite emojis 😉: Emojipedia.org 

Building the reporting

1. In the Metrics panel, click Add.
2. From the list of metrics, choose Customer Satisfaction > Rated Satisfaction tickets, then click Apply.
3. In the Rows panel, click Add.
4. From the list of attributes, choose all of the following metrics below, click Add:
   • Ticket ID
   • Ticket Solved - Date
   • Satisfaction rating - Visual
   • Ticket Satisfaction rating
5. Navigate to this website https://emptycharacter.com and copy an empty character from this page.
6. Click on the title for the column "Satisfaction rating - visualisation" on the report and paste in the empty character.
7. Your report is now complete and will look like the below:

Note: The only way to have an empty title for a row/column header is to use an empty white character. A normal blank keyboard space will not work and only display the original attribute name. 

Don't forget to add your report to a new or existing dashboard!

For more information on how to begin creating a Zendesk dashboard in Explore see the Zendesk guide: Creating dashboards