You can retrieve satisfaction ratings in your own custom reports.
For historical reasons the table that stores ratings is called ticket_feedback (but note that the satisfaction rating system is a completely separate concept from the Feedback section on the portal).
|
Field Name |
Data Type |
|
date_created |
datetime |
|
id |
number |
|
message |
string |
|
message_id |
number |
|
person_id |
number |
|
rating |
number |
|
ticket_id |
number |
|
person |
Person |
|
ticket |
Ticket |
|
ticket_message |
Ticket Message |
The possible values of rating are 1 (positive), 0 (neutral), -1 (negative).
Here's a simple example report:
The below report gives you access to the ratings and comments left:
Finally the report below gives you a matrix table containing a count per rating per agent. Note this uses the ticket messages table in the GROUP BY and WHERE clauses. This is because if we used the tickets field, if the agent was then changed after the satisfaction response was recieved, the satisfaction feedback would be assigned to the current ticket asignee. It also uses the replace functionality suggested in the comments section (thanks Kurt):
Title:
Ticket Satisfaction <1:date group, default: this_month>
Query:
DISPLAY TABLE
SELECT COUNT() AS 'Number'
FROM ticket_feedback
WHERE ticket_feedback.ticket.date_created = %1:DATE_GROUP%
SPLIT BY ticket_feedback.ticket.agent
GROUP BY REPLACE(REPLACE(REPLACE(ticket_feedback.rating, '-1', 'Negative'), '0', 'Neutral'), '1', 'Positive') AS 'Rating'