How to calculate the sum of all fields in Survey123?

Question

In order to make a line graph in the dashboard showing the cumulative number of corona cases, I need to create a hidden field in my Survey which automatically counts the numers of records. Is there a way of doing this?

My idea was to create a hidden field "def1" which has a default value of 1. Then I created a second hidden field which

calculated the total of the first hidden field i.e. sum(${def1})

This fails though. Could anyone help?survey

RobertBuckley1 · Answer

Been trying to figure this out all night, but unfortunately with no success. For a start, I cant summarize or use any featureset functions to display labels. If you have an example of how this works, i would be grateful

JamesTedrick · Answer

Hi Robert,

There isn't a way in Survey123 to calculate the total number of submissions (a cumulative count); I also don't think that's quite the correct way to work with that, as it would be possibly too fine grained (submission by submission).

One idea would be to have a feature layer that has a table of dates and a field to store the cumulative number of cases; you could then use an Arcade function to do a field calculation (utilizing one of the FeatureSet options) - you would be able to create a field calculation based on the number of cases less than the date (using the Filter function to do the query).  What’s new with Arcade: Taking a stroll through FeatureSets (Part 1)  Provides a starting point to working with this functionality.

Also asking ArcGIS Online‌ and Operations Dashboard for ArcGIS‌ for their ideas.