Assessment Instance Query

[MaheswaranK]

Hello Everyone,

I’ve a query on survey that survey responses are stored in the asmt_assessment_instance_questions table. The survey has some 10 questions. For example first question has roles manager, junior manager, senior manager like such. The value variable is getting stored as 1 for manager, 2 for junior manager like such. For each survey this is the way it is getting stored. The other 9 questions are ratings from 1 to 5. Let’s say for manager I’ve to find the average score of questions 2? How do I do that. I cannot take from the Assigned To > User Role as that role is different from what is there in the survey. I’ve to approach only by the survey. I also do not have admin role but I’ve complete platform analytics admin access. Help me with finding average of 9 questions for one particular role from question 1

[TharaS657398130]

Hello,

Since each survey question is stored as a separate record in the asmt_assessment_instance_question table, you'll first need to identify the survey instances where the response to Question 1 is Manager (value = 1). Once you have those assessment instances, you can look at the records for Question 2 that belong to those same instances and calculate the average of the rating values. The same approach can be used for Questions 3 through 10 if required.

If you find this helpful kindly upvote and mark as solution

Thank you