I am trying to put a survey123 app and a dashboard together for the corona crisis.
I want to use the survey123 to produce a webinterface to record indicents and the dashboard to present the data in real time. I have created a simple form with data regarding type of record, location etc but now I want to create statistics so that I can present total number of cases, total number of case according to city, number according to type, age, gender etc.
Can I do this in the survey123 excel sheet, or do i need to use another trick?
Assuming all of the data you are calculating your statistics from are in the feature service that Survey123 is submitting to, this is very possible.
Thanks for the suggestion. What I can't figure out though is how to label clusters. The maps show the clustered case locations, but I need to label how many cases are inside the cluster. How is this possible?
If you need to have summary map objects, you could combine the stakeholder layer with your geography layer and create a join between them - see Join Features—ArcGIS Online Help | Documentation