Choices for Questions in survey displaying backend values in report

Akshaykhare
Tera Contributor

I have created report on asmt_assessment table which shows responses submitted by user for the survey. Question in the survey are as in attached image.

Akshaykhare_1-1746528829565.png

 


But in report it is picking up backend numeric values, for ex. if user selects very satisfied then value is 5 and goes on decreasing. Similarly if user selects communication in second question then the report shows numeric 1 value. I tried changing the backend values but it is only picking numeric values. Please suggest any way so that the actual display value should be visible in report instead of backend values. 

 

3 REPLIES 3

J Siva
Tera Sage

Hi @Akshaykhare 
There is no OOB feature to show the display values. Therefore, as a workaround, create a custom string field on the asmt_assessment_instance_question table to store the display value. Additionally, create a business rule to populate the custom field based on the OOB value field. Then, in the reports, you can refer to the custom field for analysis.

Regards,
Siva

Ankur Bawiskar
Tera Patron
Tera Patron

@Akshaykhare 

As mentioned by @J Siva this is not available OOTB.

Please discuss with your customer if they are ok to add custom fields on that OOTB table and then store the display value and use that in reporting.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Help - I am having this same issue EXCEPT if the question in the survey is a multiple selection question. In that case, I can pull the selection from the table (Metric Definition => Display Name) and for this type of question, the report shows the name from the survey, this DOES not work for CHOICE type questions?

 

Why does it work as expected for one type of Survey Question and not the other?