Hello! I am have a form that is tracking attendance at project events. There is a repeat group based on the # of participants. For each participant, there is a question "What organization are they from?" which is a multiple choice pulling from a lookup table based on a caselist of organizations.
What I want to do is add a hidden value outside of the repeat group that counts the numer of unique organizations that were selected within the repeat group iterations. Somehow I can't figure out how to do this.
What I have tried is below, but I am getting an error. Any advice would be very helpful!
Oh thanks! Just to understand better - do you mean "count-selected(distinct-values...." or just "count-selected"?
Would count-selected return the "unique count" or will there be duplication based on the values. For example, if more than 1 participant is from "NGOX", I only want it to be counted once in the hidden value. I was looking at this originally:
this one
if you look at the example, it actually uses join as well I guess to keep the spaces between the choices.
try it the way they did it there. Multiple choice questions return a space separated list like the "a a b b c c c c"
remember that these values will be whatever you have defined in the value attribute of the lookup table question. so if they are unique, it will return the same values.
