Survey result Dashboard report

[John Mohr]

Hi everyone,

We are sending out a survey after an incident has been resolved.  One of the questions is asking the helpfulness of the technician.

We need 2 reports on our survey result dashboard from that question:

One to display the TOP 10 technicians (based on their average helpfulness score), the other to display the BOTTOM 10 technicians based on the average helpfulness score.

We would prefer it to be a horizontal bar chart with a color scheme to match the color rule we use for the overall average for all the technicians (in a Singe Score report) on the same page.

Has anyone done this (or similar) before?

Thanks in advance for your help!

John

[Community Alums]

Hi @John Mohr ,

You can checkout this Article : 3 Ways to Easily Report on Survey Results 

and this video :https://www.servicenow.com/community/performance-analytics-blog/simplifying-reporting-on-surveys/ba-...

[Sebas Di Loreto]

@John Mohr 

So the "technician" is the important piece of information here.

I assume you mean the "assigned_to" right?

Are these surveys for tickets on the TASK table?

What table are you using to report out? asmt_metric_result?

Are you capturing any piece of information in the survey trigger condition? (example below)

[John Mohr]

Hi Sebastian,

The technician is the ResolvedBy field.  
Yes we are using the asmt_metric_result table. 

The tasks are from the Incident table.
We aren't capturing anything specific.  Just the survey taker's responses.  When they take the survey, we report from the Metric Result table and dot walk to the Incident to get the resolved by information.  From there we use the single score report to get the average score and convert it to a percentage for the execs to easily read (like a test grade).  
The execs want to see 2 lists, one for the most helpful techs and one for the least helpful techs.  Top 10 for both.

[Sebas Di Loreto]

@John Mohr 

You can do the top 10 this way but I am afraid you can invert the logic to display the bottom 10.

Maybe creating an Performance Analytics indicator for this is the way to go.