Summarize Repeat

MarcoPoetsch

Hi all,

is there a way to summarize repeats at the end of a survey?
I'm not looking for a statistical summary, rather than summary based on a text field.

Basically, I have different conservation sites (drop down list) in a repeat that can be assessed in a single survey.

At the end of the survey I would like to have a summary of the sites (site names) that have been assessed, and ideally also those that haven't. In the most basic version it should be just saying if a site has been assessed or not. (Site A = assessed, Site B = Assessed, Site C = Not assessed)

What I have so far is a hidden calculation for each site in the repeat that checks if it is selected or not:

name		calculation
SiteACheck	...	if(selected(${Site},'Site A'),1,0)
SiteBCheck	...	if(selected(${Site},'Site B'),1,0)
SiteCCheck	...	if(selected(${Site},'Site C'),1,0)

And at the end I have again for each site a field (note) that shows if a site got selected (if SiteXCheck = 1).

I'm sure there is better way to do this. Any ideas?

 

dougbrowning

Is it a count up for a total or just a yes no?  If you want a count then what you posted is the standard.

If you just want a yes or no then a join and a contains may do the trick.

You can also use a dashboard or arcade after the fact also.  I have been going this route more since we have users update data in the webmap, which skips the form, so none of the calcs update.  Watch out for that one.

Hope that helps