I'm working on creating a few reports to put on a dashboard for supervisors to use to keep an eye on their satisfaction scores from user surveys that are sent out after incident closure. In order to get the correct data it appears that I will need to create a database view using the tables asmt_assessment_instance and asmt_metric_result. I have created this database view but am running into the issue where I am only showing 1 result, even though the record counter is saying it's showing record 1-20 of over 81,000 records. I have my database view set up like below and hoping someone can point me in the direction of getting this resolved.
asmt_assessment_instance - prefix = asmtinst - order 100 left join = false
asmt_metric_result - prefix=rslts - order 200 left join = true where clause = asmtinst_number=rslts_instance
