Hi,
I have a workflow in which I am names of teachers from 20 students using
repeat groups. We enter information about each student which includes who
their teacher is.
After looping through all 20 students, I want to find out how many students
each teacher has and pick out the top three teachers with the most students.
Any pointers on how I can achieve this?
Kind regards,
Sam
Sam,
There is no easy way of doing this.
You could put teachers in a select one, then used indexed-repeat() to
find the teacher values in each student. Then a lot of if() statements
that store a 1 if you match the known teacher.
Pseudo code would look like this:
student_1 = indexed-repeat(/data/students/teacher, /data/students, 1)
student_2 = indexed-repeat(/data/students/teacher, /data/students, 2)
teacher_a = sum(if(student_1 = teacher_a, 1, 0), if(student_2 =
teacher_a, 1, 0)...
teacher_b = sum(if(student_1 = teacher_b, 1, 0), if(student_2 =
teacher_b, 1, 0)...
Finding the top three is even messier. You could try using some
combination of max() or a ton of if() statements, but that sounds
painful. You could also list the results and maybe have the user pick
the top 3. Or just leave that as a server side calculation.
Yaw
On Sat, Aug 23, 2014 at 4:59 AM, Ruralnet Kalundu ruralnetkalundu@gmail.com wrote:
Hi,
I have a workflow in which I am names of teachers from 20 students using
repeat groups. We enter information about each student which includes who
their teacher is.
After looping through all 20 students, I want to find out how many students
each teacher has and pick out the top three teachers with the most students.
Any pointers on how I can achieve this?Kind regards,
Sam
--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.