Learner evaluation report
Content (please ensure you mask any confidential information):
I have created learner evaluation report where in I want each question text to be a column:
I was able to achieve the results but in the above manner, I want to group the data and added the aggregation logic of max at the rows but its still not working.
If I am adding the below code in question formula then its working fine except for the last field which is CLOB:
MAX(CASE "Learning Evaluations"."Question Text" WHEN 'What part of the course did you find most useful and interesting?' THEN "Learning Evaluations"."Answer Text" ELSE NULL END)