Survey Reporting

[Paul Perilman]

Is there a way to create a report for a particular survey that shows the response as the row and the string values for each as the columns? Ideally this is how you would report on a survey. My understanding is this was supposed to be in the Utah update but I don't see a table or option for that.

[Dharmaraj5]

Hello @Paul Perilman ,

You can achieve your requirement by doing report with following condition.

Table : asmt_metric_result

Condition : Metric.category.type is [your survey name];

fields: Metric, Assigned to , String value (for writting question), Actual value(integer value)

[Berin · Accepted solution]

Yes, but you need to create a Database View to do it.  There's an oob UI Action (View Responses in Rows on the Survey Definition form) that I find useful.  It automatically generates a Database View for you!  😁

In order to use it, you first have to have at least one response to your survey, and the survey can only have a maximum of five active questions.  (If your survey has more than five questions, you can temporarily set some as inactive, use the UI Action, and then set them back to active once the Database View has been created.)

If you then have a look at the design of the Database View, you'll be able to see how the survey questions are linked and displayed, and then add as many additional questions as you need.