AnsweredAssumed Answered

Count of Checkbox Field that has 84 Values

Question asked by ZhizhongNeo on Jan 5, 2011
Latest reply on Jan 6, 2011 by ZhizhongNeo

Title

Count of Checkbox Field that has 84 Values

Post

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?

student_scheduler.png

Outcomes