Serenade Posted October 3, 2015 Share Posted October 3, 2015 I know I have the option to see ticket feedback scores, but I can't seem to find any sort of way to view the average star rating users leave on replies. Where can I view these? If I can't what's the point? 0 Quote Link to comment Share on other sites More sharing options...
sentq Posted October 3, 2015 Share Posted October 3, 2015 you can make custom report to calculate these values and give you the total average 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted October 3, 2015 Share Posted October 3, 2015 there is already a report that shows the scores and average.. http://docs.whmcs.com/Reports#Ticket_Feedback_Scores Ticket Feedback Score When the Ticket Closure Feedback option is enabled, this report displays the ratings given to individual admins by clients. Can be filtered by date range. Click the admin's name to see comments left specifically about that member of staff. if it currently doesn't give you the info you want, you can adjust the sql query by modifying the report code. 0 Quote Link to comment Share on other sites More sharing options...
Serenade Posted October 3, 2015 Author Share Posted October 3, 2015 there is already a report that shows the scores and average.. http://docs.whmcs.com/Reports#Ticket_Feedback_Scores if it currently doesn't give you the info you want, you can adjust the sql query by modifying the report code. This is the Ticket Closure Email Feedback. I'm looking for the star ratings. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted October 4, 2015 Share Posted October 4, 2015 This is the Ticket Closure Email Feedback. I'm looking for the star ratings. my apologies. a simple SQL query to calculate the average for these star ratings would be... SELECT tblticketreplies.admin,avg(tblticketreplies.rating) as average FROM tblticketreplies WHERE tblticketreplies.rating > 0 that will give you two columns, the admin name and their average star rating (i'm ignoring where no rating is given). 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.