Select to view content in your preferred language

Summarizing Repeats; sum of field 2, grouped by field 1

360
1
01-04-2024 12:31 PM
DouglasKnabe
Occasional Contributor

I don't think this has been answered previously. If it has, I was unable to find it and I apologize in advance.

I have a repeat section wherein users select a species (from a select_one list question, enter a count, then move to the next (repeat). The same species can be repeated numerous times. The data would look like

Species14
Species28
Species315
Species22
Species29
Species123
Species41
Species36

 

I would like to summarize the data such that the total sum for each species is displayed as such:

Species127
Species219
Species321
Species41

 

I know I could create calculations to do these individually, but there are over 70 species, and more could be added later, so doing this dynamically to minimize the effort needed to update the survey would be best. I'm not worried about whether or not this summary is output to the data, I simply want to display it (note, grid, whatever is necessary).

0 Kudos
1 Reply
abureaux
MVP Frequent Contributor

Within your survey? Nope. You'll need to add a calculate for each species unfortunately.

0 Kudos