I have a survey which collects event information and the volunteers who participate at each event. The volunteer and paid hours are tracked.
In my survey the volunteer info is a repeat to capture multiple volunteers per event.
I need to generate a report showing the sum of volunteer and paid hours. Can someone point me in the direction (possibly with a related example. I did see the photos one.) ? Much thanks in advance?
Edit: (oops) For a new survey:
Try making a separate "hidden" or "calculate" question outside of the repeat with count(repeat), sum(repeat), or join(repeat) in the calculation field (your use case is probably sum() ), and then have your report only draw from that question, rather than the repeats themselves.
Repeats—ArcGIS Survey123 | Documentation (See Aggregation section)
Sorry, not sure off the top of my head for after you have the data