Survey Reporting - Where to start?

[jeffswales]

Hi all,

I'm looking for some advice / starting points for Survey Reporting. I've been tasked with taking a a survey from SNOW and presenting its data into an interactive dashboard. (which I've previously explored for Incident, Problem and Change). I've tried searching the forums and looking through a few guides but when trying to pull data from the tables they suggest I can't find my surveys data.

For instance my opening question is "Which area of the business do you report to" this then provides the user with a choice of lets say 8 departments. From this I want to be able to pull the data showing how many people have completed the survey for each department, then upon clicking one department it would show a breakdown of all answers relevant to that department. 

I only have limited access to SNOW (reporting admin, survey admin and ITIL) but am very confused as to where this data is recorded and what the field names are in the background.

If anyone has any advice with where to start for Survey Reporting I would really appreciate the assistance. 

Thanks,
Jeff 🙂 

[Slawek_Radziewi]

It might be not so easy as you can see. 

I am reporting on asmt_assessment_instance table to see how many new surveys have been created.

I would suggest going to survey Overview dashboard and check reports used there. How they are created and what condition etc. and reuse them. 

https://****.service-now.com/home.do?sysparm_view=survey_new_overview

[kchorny]

You can define which fields you want to capture in the Trigger Condition for the Survey.  

Survey - View Surveys

Open your survey

Scroll to the bottom, you should see Trigger Condition related list

Create a trigger condition and set the values that you want to capture from the related task in Related Field 1, Related Field 2, Related Field 3 and Related Field 4 (you have to select the table first).  For example, in our case we want to know who the incident was assigned to, which group it was assigned to, and who resolved it.

Once you have some data (IE some users have completed surveys after you made the above changes) you can report on them from the Metric Result (asmt_metric_result) table, add a filter where Instance.Metric Type = the survey you are reporting on.  Then you can pull the related field values from the Instance.related records fields.  Their response is in the String Value field.  You can display the actual question by showing the Metric.Question field.