New to survey 123, I have created a survey that collects weather data. I would like it to keep a running total of snowfall for the season based 24 hour snowfall. Is it possible to perform a calculation based on the previous days answer?
Hi. It depends on how you configure the survey:
From a practical perspective, you may want to keep your survey simple and go with an option where weather data is reported one day at a time (without a repeat). Using HTML formatting in the label of a note question, or in the description of the survey, you could link into an external web application where the user could look at the aggregated data. You could for example use Web AppBuilder to filter by station/month, aggregate the weather data and then simply link to your web app from the survey.
Suppose that you go for the option with the repeat block, then you need to use sum() and count() functions to aggregate values for some fields from all responses. BUT, what if you need to access all the responses from these fields?
I've a similar case where I need to display all the responses to some fields in the repeat group, going through the documentation for XLSForm I discovered that there is also a join() and a indexed-repeat() functions to access data inside the repeat group.... It seems that these functions are not yet supported in Survey123 or, at least, I can't make them work...
Do you have any insights on this?
Thanks in advance,
Retrieving data ...