Running report on asmt_assessment_instance but cannot display assessment answers

[hanaphouse]

I was trying to run a report under asmt_assessment_instance to get:

• All surveys (responded and not-responded)
• If responded, show response.

However, I can't seem to find the right column to show the response. Can some point me to the right direction?

[sachin_namjoshi]

you can report on question_answer table to find out response.

Regards,

Sachin

[hanaphouse]

However, I still want to view all other surveys without answer on the same list view.

[Jaspal Singh]

Hi,

You can create a report on Metric Result (asmt_metric_result) table as below.

Group by: Instance.Task

Category : Its a dot-walk of Metric. So, look for Metric.Category & replace your survey name

[hanaphouse]

Unfortunately, this only shows the completed surveys.

This is a sample output: