Calculations on an unknown number of fields

Question

Hello,

I have a survey for a number of measurements, in total 32. The measurements compose a matrix of 4 by 8 (4 different heights, 8 different wind directions). Not all points must be measured, it is up to the field guy which measurements he/she takes.

All possible measurement points are represented by an integer question in my survey. For various reasons I am not using repeats.

Now, I want to make some calculations like max(), min(), sum(), avg(), but only for those measurement points that do have a value.

Does anyone have a tip how I can tackle this task (efficiently) in Survey123?

Thank you very much, best regards,

Jürgen

JürgenBiendara1 · Answer

Hi James,

Meanwhile I found ways to calculate min(), max(), and avg() for my fields. But now I see other problems. I have up to eight measurements for one object. For these measurements I calculate min(), max(), and avg(). The object is in a repeat, i. e. I can have more than one object. I want to calculate min(), max(), and avg() individually for each object.

1. The calculation of min(), max(), and avg() for the first object is working perfectly. But when I create the second object, min() and max() of the first object are retained (here with four measurements).

2. Although I set "allowUpdates=true query=’1=1’" in column "bind::esri:parameters" for this repeat, some of the values are not loaded down to the surveys in my inbox.

I am using note questions to display the calculated values since it does not work with integer or decimal questions. Maybe these observations help to narrow down the problem with calculations in a repeat.

Best regards,

Jürgen

JamesTedrick · Answer

Hi Jürgen,

Thanks for bringing this example.  Support for aggregation functions is still be examined.

JürgenBiendara1 · Answer

Hi James,

There seems to be a problem with the max() and min() functions in nested repeats. Please see the attached example. Here, the max() function does not work. But, as soon as you delete the outer repeat, the max() function works as expected. Any chance to get around this problem or to fix it?

As for the average function: I found a solution in an older thread here in GeoNet -> How to implement this formula in Excel Form (Survey123)

But, in my case with 32 questions to be averaged, this solution seems to be very cumbersome. Can you think of an easier way to do this? (Please also see the attached survey which has only 8 integer questions. The intended structure is the same but with four groups of eight integer questions each.)

Thank you very much, best regards,

Jürgen

Max_In_Nested_Repat.xlsx