Help with Servicenow Survey reports

[cicgordy]

Hi all, 

I have created surveys for incident and request using Servicenow inbuilt functionality. Now I need to create reports, can anyone recommend a list of what tables I should use and what conditions should I set up to get the best of the reports listed below:

- Survey completed in the last 7 days

- weekly average score

- weekly average score by assignment groups

- score is 5 or less

- weekly responses   

- survey completed by company, country, location

- negative, neutral, positive

Many many thanks 🙂

[Sai Shravan · Accepted solution]

Hi @cicgordy ,

To create the reports you listed, you will need to use the following tables and set up the specified conditions:

Survey completed in the last 7 days: Use the survey_response table and add a condition on the sys_created_on field to only show responses created in the last 7 days.

Weekly average score: Use the survey_response table and group the results by week, using the sys_created_on field. Then, calculate the average score using the survey_question_response.score field.

Weekly average score by assignment groups: Use the survey_response table and group the results by week and assignment group, using the sys_created_on and assignment_group fields. Then, calculate the average score using the survey_question_response.score field.

The score is 5 or less: Use the survey_question_response table and add a condition on the score field to only show scores less than or equal to 5.

Weekly responses: Use the survey_response table and group the results by week, using the sys_created_on field.

Survey completed by company, country, location: Use the survey_response table and group the results by company, country, and location, using the company, country, and location fields.

Negative, neutral, positive: Use the survey_question_response table and group the results by the score field, where score <= 2 is considered negative, score = 3 is considered neutral and score >= 4 is considered positive.

Please note that the names of fields, tables, and conditions may be different in your instance, so you may need to adjust them accordingly.

Regards,

Shravan.

Please mark this as an appropriate response as correct so that the question will appear as resolved for other users who may have a similar question in the future.

[cicgordy]

Many thankssssssssssss