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
