Create a dashboard and scheduled reports from a survey results

[velvet]

We are beginning to use surveys.  Each answer on the survey has a number value.  I need a dashboard and report that would show the following and I don't know how to start it, especially the part with the average score of the survey based on groups because assign to of the survey is the person taking the survey, not the Assignmenr group of the Incident that generated the survey.

[Adam Stout]

I believe there are a few posts here on this, but the secret to getting started is using views.  You need a database view to join the survey results to the incident so you can dot-walk to get the fields you need from both.

[brianmccargar]

We had similar issues reporting a survey scores for incident.

Reporting we use the Metric Result [asmt_metric_result] table

Then in order to get the assignment group, you need to dot walk to the Instance.Task.Assignment Group. 

We created a number of reports some by the assignment group, using both the is (dynamic) My Groups, and we did some for the incident assignee as well. We also created an interactive filter that can be applied to dashboards, so users can filter the dashboard to the incident closing assignment group. 

[Pratiksha Kalam]

Hi,

Refer below block,

https://community.servicenow.com/community?id=community_blog&sys_id=ee1e626ddbd0dbc01dcaf3231f961923

If my answer is worthy mark it helpful and correct

Regards,

Pratiksha

[Ashutosh Munot1]

Hi,

I will tell you where to start first. The easiest way to start with OOB Report is under related links on the survey form.

See below image:

This will give you the response's scorecard for the current survey.

Now if you want to report for all the survey's in your system then we always create a report on asmt_metric_result.

Also you can go to Survey Module in left navigation and click on Overview. There you can see many reports which you want.

Thanks,
Ashutosh