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
Species1 | 4 |
Species2 | 8 |
Species3 | 15 |
Species2 | 2 |
Species2 | 9 |
Species1 | 23 |
Species4 | 1 |
Species3 | 6 |
I would like to summarize the data such that the total sum for each species is displayed as such:
Species1 | 27 |
Species2 | 19 |
Species3 | 21 |
Species4 | 1 |
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).
Within your survey? Nope. You'll need to add a calculate for each species unfortunately.