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,