Report on customer Satisfaction survey with Smileys

[Shriyansh]

Hi Team,

I have a requirement to create a report on responses under Customer satisfaction survey with Smiley.

It is triggered once incident ticket is closed.

Just want to fetch report with responses and with incident number.

Regards, 

Shriyansh

[Sebas Di Loreto]

@Shriyansh 

You should use the asmt_metric_result table for your report (screen below on how it looks).

You can use the ACTUAL VALUE field

An answer with the yellow face is actual_value=2 for example.

[Shriyansh]

Hi @Sebas Di Loreto ,

Can we get the Display values of Responses like "Satisfied"/"Dissatisfied" and also can we get Incident numbers as well in same report.

Regards,

Shriyansh 

[Sebas Di Loreto]

@Shriyansh 

Of course. The trick is to dotwalk the instance.task.

String value gives you the "Satisfied/Dissatisfied".

These are the fields on the columns you see above.

[AndersBGS]

Hi @Shriyansh ,

please see other community post here where same question has been answered: https://www.servicenow.com/community/now-platform-forum/how-to-add-the-smily-sad-and-neutral-happy-f...

if my answer has helped with an answer for your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders