I am producing a feature report and would like to summarize the individual entries in a select_multiple question.

Users have the options to select any combination of A, B, C, D. I would like to be able to count across all records how many times each individual answer (A, B, C, or D) appears. The documentation only notes legal WHERE clause, so that if I broke them each out (e.g. where: "field = 'A'") it would only count options where 'A' was the only option chosen (ignoring A,B or A,C,D etc).

Is there a technique to count every time 'A' is chosen? E.g. in stead of WHERE field = 'A', an equivalent of field LIKE '%A%'?

This is possible using feature sets in dashboards to break them out and summarize them individually but it would be really helpful to count them up in a report.

  • In the survey itself there is a 'selected()' function... It's not a great workaround but maybe you could add a new calculated field to the survey itself, something like if(selected(${q1}, 'A'),1,0)+if(selected(${q2}, 'A'),1,0)+...
    – Brennan
    Aug 19, 2022 at 19:50
  • I think that would be the next step if I can't find a solution within the reporting structure....it seems like the kind of thing that should exist so I'll hold out hope a little longer. I'd rather not alter the table but if that's what I have to do that's what I have to do.
    – TravisB
    Aug 22, 2022 at 16:04


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.