topic Re: Show Field Total in Dashboard in ArcGIS Dashboards Questions

Show Field Total in Dashboard

Anonymous User — Thu, 03 Jun 2021 15:00:38 GMT

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!

Re: Show Field Total in Dashboard

DavidPike — Thu, 03 Jun 2021 15:18:48 GMT

Should be possible. Add Indicator Element -> Choose your feature as input -> 'Data options' -> Statistic - 'Sum', Field - 'totalvictims' -> Done

Re: Show Field Total in Dashboard

Anonymous User — Thu, 03 Jun 2021 15:44:46 GMT

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.

Re: Show Field Total in Dashboard

Anonymous User — Thu, 03 Jun 2021 16:55:49 GMT

So I created a new integer question in the survey and that solved the problem. Thanks!

Re: Show Field Total in Dashboard

NajmehServatsamarein2 — Tue, 22 Mar 2022 21:05:27 GMT

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 !

Re: Show Field Total in Dashboard

DavidPike — Wed, 23 Mar 2022 19:13:03 GMT

What's the field data type?

Re: Show Field Total in Dashboard

NajmehServatsamarein2 — Wed, 23 Mar 2022 20:52:47 GMT

It is String.

Re: Show Field Total in Dashboard

DavidPike — Thu, 24 Mar 2022 15:53:28 GMT

needs to be a number.

Re: Show Field Total in Dashboard

NajmehServatsamarein2 — Thu, 24 Mar 2022 15:58:40 GMT

yes I changed it this morning. and it works. thank you.