Hi, I want a widget on a dashboard which displays the responses of 5 question related to activities perform by students (q35_1 to q35_5). Those responses are numeric and they represent number of hours spend by students for each activity (if the students spends time on it otherwise it left blank).
I am trying to display the total average of those 5 questions (sum of 5 questions / count of responses of all those 5 questions).
I tried to use custom metrics but the metrics is not to display data (can’t be use as a value). If anyone knows how to build a widget to display the total average of 5 questions all combined please let me know.