topic Re: Dashboard count inside field in ArcGIS Dashboards Questions

Dashboard count inside field

EricS — Mon, 12 Nov 2018 13:41:31 GMT

I need to add all the numbers in one field to get a total. I dont see where I can do that. It only does an occurrence count.

example

interactions

Need my dashboard count to show 12 for adding all the numbers from field interactions not that there were 3 occurrences

Re: Dashboard count inside field

MitchHolley1 — Mon, 12 Nov 2018 13:52:28 GMT

How are you trying to display this count? In a chart? In a gauge? Please elaborate on the question and give as much detail as possible.

Re: Dashboard count inside field

EricS — Mon, 12 Nov 2018 14:05:41 GMT

I am using an indicator

Re: Dashboard count inside field

MitchHolley1 — Mon, 12 Nov 2018 14:13:04 GMT

Use the 'Sum' statistic method.

Re: Dashboard count inside field

EricS — Mon, 12 Nov 2018 14:36:37 GMT

When I select SUM I get a "No data" on my indicator

Re: Dashboard count inside field

MichaelVolz — Mon, 12 Nov 2018 14:43:20 GMT

Is the data field that you are trying to summarize Numeric?

Re: Dashboard count inside field

EricS — Mon, 12 Nov 2018 14:49:13 GMT

yes it is

Re: Dashboard count inside field

EricS — Tue, 13 Nov 2018 14:18:20 GMT

Hi Michael

Is there a way to get the sum of the numbers inside the field?

Re: Dashboard count inside field

MichaelVolz — Tue, 13 Nov 2018 14:24:40 GMT

Did you try using Developer Tools in the web browser to see if any errors were being thrown?

I asked if it was numeric as you can store numbers in a text field, so it would appear on the surface to be a numeric field.

What kind of numeric field are you using (short integer, long integer, float)?

Re: Dashboard count inside field

EricS — Tue, 13 Nov 2018 14:32:08 GMT

I am using long integer

Re: Dashboard count inside field

MichaelVolz — Tue, 13 Nov 2018 15:40:41 GMT

Is the service being used originating from an on-premise ArcGIS Server where the service is registered with AGOL or are you using an AGOL hosted feature layer?

If it's the former than maybe you are running into a similar issue that is illustrated in the following thread:

Sum Statistic not calculating correctly in Operations Dashboard web app

The poster never mentioned if they solved their issue, but the OpDash Indicator did work as expected when using an AGOL hosted feature layer. So if it's your org's own AGS service, then I would create an AGOL hosted feature layer to see if that fixes the issue. If it does but you don't want to use an AGOL hosted feature service, then I would talk to ESRI tech support about this issue as it may be a bug with on-premise services registered with AGOL.

Re: Dashboard count inside field

EricS — Tue, 13 Nov 2018 15:48:20 GMT

I am pulling data from Survey123 and the field is a number field so I dont

have room in changing anything. Im surprised there is no way to display a

sum total of all the numbers in the same field

Re: Dashboard count inside field

EricS — Thu, 15 Nov 2018 15:41:21 GMT

Hi Michael

Is there any solution to getting the dashboard to count the numbers in the

field column rather than by occurrence?

Re: Dashboard count inside field

MichaelVolz — Thu, 15 Nov 2018 16:41:41 GMT

Eric:

I think Mitch Holley showed how to setup the Indicator widget to get a sum of records. I'm thinking it might be the connection to Survey123 that might be causing an issue. As such, I would create an incident with ESRI tech support so they can determine what the issue is.