Count of Checkbox Field that has 84 Values
Hi, i am facing this problem whereby i have to count the frequency of each checkbox value of a TimeSlot Field.
My Student Schedule::Available_TimeSlot Field has 84 checkboxes: TS001 to TS0084 and the field is based on a valuelist of another table TimeSlots::TimeSlot ID.
What i want to accomplish is to find out which are the top 3 time slots that has the most students.
Hence, I need to count the frequency of each timeslot that occurs in my students records and then present the top 3 timeslots in a graph/field/etc.
I'm thinking of creating 84 fields that uses Summary of Count of each value but there are 2 problems
1. It is very tedious
2. Any new time slots will not be updated dynamically.
Is there a better alternative to it?