nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sum Statistic not calculating correctly in Operations Dashboard web app

MeredithDutlinger1

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!

Find more posts tagged with

Accepted answers

All comments

DiegoMonge_Chinchilla

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.

Captura de pantalla 2022-02-18 090236.png

MeredithDutlinger1

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!

MeredithDutlinger1

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 ....

mvolz47

Are you using a query layer?

DanPatterson_Retired

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?

MeredithDutlinger1

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!

DanPatterson_Retired

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?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.