topic Average value inside repeats in ArcGIS Survey123 Questions

Average value inside repeats

PamelaLandy — Tue, 15 Jan 2019 09:55:52 GMT

Hi, Is there any option to calculate the average (the sum of each value entered divided by the number of values entered into a repetition (has no defined value) and can be calculated?

p.e.

"If you enter 02 values, then divided by 02, if you enter 03 values, divided by 03, if you enter N values divided by N "

I think I've only seen it within ideas of improvements.

Re: Average value inside repeats

NicolasRoger — Tue, 15 Jan 2019 13:47:44 GMT

It can be done. Here is how I do it in my survey:

Create 2 field Outside the reapeat group. One field will use the function Count() on a field within the repeat group and the other will use the Sum() function on that same field.

Then simply divide the results.

Re: Average value inside repeats

PamelaLandy — Tue, 15 Jan 2019 21:03:26 GMT

Thanks, Nicolas

Re: Average value inside repeats

SilverwoodConsulting — Thu, 01 Apr 2021 17:17:16 GMT

Alternatively, create a new row (or field) outside the repeat to calculate the average. The calculation would look something like this:

(sum(${Question_1})) div (count(${Question_1}))