We are trying to create a Survey123 report template that exports a summary table of wildlife species observed within our Survey123 forms. However, we would like the species to only be represented once. Currently our code for grabbing the species and placing in ascending order is as follows:
$<$summary>
${#wildlife_observations| orderByFields:” wildlife_observed ASC” ${wildlife_observed}
${/}
Would someone be able to assist us with the additional command we need to have each species represented only once in our table? The data is collected within a repeat single select with associated domain list.
Hi @Bio_GIS,
Have you looked into the groupByFieldsforStatistics parameter of the stats method? It's documented in the Survey123 Report queries>Aggregate functions section of the documentation and there's an example in the Survey123 Report queries>Include select value section.
Thanks,
- Barbara