topic Re: Sum Statistic not calculating correctly in Operations Dashboard web app in ArcGIS Dashboards Questions

Sum Statistic not calculating correctly in Operations Dashboard web app

MeredithDutlinger1 — Mon, 29 Jan 2018 15:33:08 GMT

I am trying to use a Sum Statistic in the Indicator and Graph elements, using an Acreage field in the calculation. I have tried two layers of the same data, one map service and one feature service hosted by ArcGIS Server 10.3.

The Sum is incorrect; it is way over-calculated. The Average, Min and Max statistics seem to work fine on the same data. I've also tried other number fields in the same data with no decimals, but get the same results (overcalculating) using the Sum statistic. Any ideas on this? Thanks!

Re: Sum Statistic not calculating correctly in Operations Dashboard web app

DanPatterson_Retired — Mon, 29 Jan 2018 21:57:26 GMT

sort the field in descending order, are there any large numbers in there that don't make sense?

sort in ascending order, are there any large negative numbers in there that don't make sense?

Re: Sum Statistic not calculating correctly in Operations Dashboard web app

MeredithDutlinger1 — Fri, 02 Feb 2018 21:04:04 GMT

Hi Dan, thanks for your reply. No, there are no numbers that do not make sense. There are some very small numbers (.05 acres) and some large ones (2,789 acres), but they make sense and are accurate representations of the parcels. I can say though that the Sorting itself acts weird ... meaning it wont sort all of the records together; instead it appears to sort chunks of records together, but as you scroll down the attribute table, you will see another big (or small) number and the sorting order starts over, and then another chunk after that acts the same way. Not sure that means anything but ... anyway! I'm using a feature service hosted by our Server and portaled via ArcGIS Online. Thanks for any insight!

Re: Sum Statistic not calculating correctly in Operations Dashboard web app

DanPatterson_Retired — Fri, 02 Feb 2018 22:07:57 GMT

Your second last sentence... service, server, portaled via ArcGIS online..,.

I suspect that is the source of the problem, especially when you mention chunkiness.

I don't suppose you can work with locally stored data to see if it is your source of data that is causing the problems?

Re: Sum Statistic not calculating correctly in Operations Dashboard web app

MichaelVolz — Sat, 03 Feb 2018 01:22:52 GMT

Are you using a query layer?

Re: Sum Statistic not calculating correctly in Operations Dashboard web app

MeredithDutlinger1 — Wed, 07 Feb 2018 02:05:32 GMT

in fact it is the trouble maker! thanks for that suggestion ... when i create a hosted feature layer of the exact same data/symbology via AGO, the records sort just fine and the sum statistics add up correctly. time to contact IT! thanks again ....

Re: Sum Statistic not calculating correctly in Operations Dashboard web app

MeredithDutlinger1 — Wed, 07 Feb 2018 02:08:28 GMT

hi and thanks for reaching out! i wasn't using a query layer, no ... per Dan's advice below, i tried the same operations on a hosted feature layer and everything worked fine, including sorting and sum statistics. must be something in the service itself ... always good to narrow things down and i appreciate your suggestion for troubleshooting!

Re: Sum Statistic not calculating correctly in Operations Dashboard web app

DiegoMonge_Chinchilla — Fri, 18 Feb 2022 15:02:53 GMT

Hello this happening to me, must be a bug to fix
Now I have this data 14+13+24+23+21+21 and I get 95 instead of 116.