Reporting on survey responses

[SowmyaS99338320]

I want to create a report based on the survey response where the user entered the unsatisfaction reason should be displayed in the report. 

example: Survey has a question Why were you unsatisfied? and it has the options 1)Too long to answer my call 2)Too long to fix my ticket  3)No update or feedback provided on my ticket 

User entered the response that should be displayed in my report. Can someone assist me how this can be done?

[Dr Atul G- LNG]

Hi @SowmyaS99338320 

If I understand correctly, these three answers are entered by users as free text in the field, rather than being fixed values like choices or radio buttons in the survey. If that's the case, creating a good report might be challenging since users might phrase their responses differently, leading to inconsistencies. Or is my understanding incorrect here?

You can check the survey responses under the Survey Response table.

[SowmyaS99338320]

Hi Atul,
It is not a free text but choice field.

[Dr Atul G- LNG]

Then it is easy

Go to asmt_metric_result 

and try here to filter with value. and same you can do it at report. 

[SowmyaS99338320]

The string value is working but unsatisfied reasons which was selected by the user is in another table asmt_metric which needs to be displayed.