Hello. I have a field in my Survey123 (screenshot attached) that has a number value for the number of victims in each individual survey taken in our Damage Assessment field survey. I want to show, somewhere in the dashboard, the TOTAL of all victims across all surveys taken, so basically the total sum all the values in this field. I cannot find a dashboard element that will do this - I was hoping Indicator would allow me to do this somehow, but I have not found a solution yet. Is this possible to show?
Thank you!
Solved! Go to Solution.
Should be possible. Add Indicator Element -> Choose your feature as input -> 'Data options' -> Statistic - 'Sum', Field - 'totalvictims' -> Done
Should be possible. Add Indicator Element -> Choose your feature as input -> 'Data options' -> Statistic - 'Sum', Field - 'totalvictims' -> Done
Hello , i have same problem with total service unit. when i select Data options' -> Statistic - 'Sum', the only field i can see is object ID. there is no service units field !
What's the field data type?
It is String.
needs to be a number.
yes I changed it this morning. and it works. thank you.
Thank you for your reply, this should definitely be the solution. However, this field does not show up as an option once I select 'Sum'. The question type in the survey is 'calculate' which apparently is not a numeric field. I am not sure how to format it as a numeric field which the dashboard will recognize.
So I created a new integer question in the survey and that solved the problem. Thanks!