Hello all, I have a requirement to build a report to show all third parties who answered to specific questions (Risk questionnaire) and with specific responses. I'm using "asmt_metric_result" table to get the association between the third party -> question -> responses but i'm unable to create an AND condition for specific questions and responses. Here is an example of the scenario i'm trying to create
E.g. Show me all the third parties who answered to Question #1 and question #5 and question #10 and Q1 response = 'N/A' and Q5 response = 'Yes' and Q10 response = 'Likely'
I guess I need to create a row to column transpose to create the desired results or use an DB view to get the results. Can someone please help me on how to achieve these results?
Thank you.
