Reporting on Surveys CSATs

[AnthonyMull]

Hi community

I would like to understand how to report of CSATs please.

How can I see the following:

1. List of surveys grouped by score.

2. Tickets that the survey is related to.

3. User that submitted the tickets.

If you can point me to the tables and fields and easiest method to do this that would be helpful.

Thanks in advance.

[dacolon]

Question about CSAT reporting: How to prevent empty results (buckets) as noise in reports?

[shubhamseth]

@AnthonyMull There is out of box from ServiceNow something on survey 

Check if this helps you 

https://www.servicenow.com/docs/r/zurich/servicenow-platform/survey-overview-module.html

[AndersBGS]

Hi @shubhamseth 

Have you looked at the link before posting:

The Survey Overview dashboard is deprecated. It is no longer deployed, enhanced, or supported.

[shubhamseth]

@AndersBGS 

My bad! I overlooked the Note that is present right there. Sorry for the confusion. However, this was one of good stuff as I had used this earlier. Thank you for brining up to my notice! Appreciated! 

@AnthonyMull Please ignore my previous reply. Let me find out the best way to tackle your requirements and come back. 

[Mark Becker]

The table for survey results is usually asmt_metric_result unless your dev team created different solutions than out of the box.

Your list of surveys should come under the Metric.Type field so you'll have to dot walk to that.

The user that filled out the survey is on the original table under Assigned to field BUT the user who completed the task that is getting 'rated' is under the Task.Assigned to field. 

Hope this helps.

Thanks!