ArcPro not honoring selection for attribute statistics

5564
18
11-04-2022 10:11 AM
ChristopherJStrong
Occasional Contributor

All I'm trying to do is get a total value for the Shape.STLength() field for a feature class. I've selected the records I care about, but when I right click on the field and choose statistics, I get the statistics for all records. The attribute table is only showing selected records, and the only filter option is by extent.

What am I missing here?  This should be very simple (and it is in ArcMap, which I am seriously wishing I could just use forever).

Screenshot attached. 

selectionissue.JPG

18 Replies
Robert_LeClair
Esri Esteemed Contributor

I can confirm this is BUG-000153835 - Incorrect statistics are displayed for a selection of features if the selection is made prior to creating the field statistics chart and the data resides in an eGDB.  I created a PosgreSQL eGDB and saw the same behavior as you as well as the term "selection" briefly appearing before it disappears.

Current workaround is:

  1. Open the chart properties first and make the selection in the map second.  You'll see the expected statistics in Chart Properties but the chart will not update.
  2. Copy the data into a file geodatabase and conduct the workflow there.

The BUG is currently under review by Esri Support Services and the Geodata team.

AZendel
Frequent Contributor

I'm seeing this on an Oracle EGDB as well. I'm still using Pro 3.0.3, but 3.1.0 is available. But based on the bug report, I don't think this this has been fixed. @Robert_LeClair, it may not hurt to let the staff that are addressing the bug know that I've run into the issue on an Oracle SDE instance as well. It's happening on the SHAPE.Area field and a separate double precision field that has nothing to do with the geometry. 

I'm glad that the statistics that it was reporting were so out of the park that something was blatantly wrong. Otherwise, I could have reported some bad numbers and that should never be considered acceptable. I think this bug warrants faster action than it appears to have received so far. 

Robert_LeClair
Esri Esteemed Contributor

@AZendel - so I looked into this briefly and what I've learned is the BUG-000153835 is currently under review by the ArcGIS Pro Dev Team and that the workaround I provided 1/30/23 worked for ArcGIS Pro 3.0.x but no longer works for ArcGIS Pro 3.1.x.  Now the BUG is for SQL Server 2019 rather than Oracle.  I do not have the ability to create a new bug for Oracle and/or add it to the current bug as I work in Training Services but I do recommend you contact Esri Support Services with this report so they're aware of it in this RDMBS too.  Thx!

by Anonymous User
Not applicable

Still seeing this bug in Pro 3.1.1 and SQL Server sde geodatabase. I'm reaching out to tech support.

by Anonymous User
Not applicable

Added my case to -

  • The statistics field not honoring the selection is a BUG-000153835 that can be reproduced when you try to work with data sources from a SQL Enterprise geodatabase
CurtisTyler
Emerging Contributor

There is this thread from 2022 that discusses this issue and within the "solution" it is stated that apparently it's part of a "performance enhancement" introduced in 3.0. The documentation referenced in the linked thread is here.

alex_friant
Frequent Contributor

Wow, you're right. There it is right there.
esri_documentation.png

They should add a tool tip when you hover over those options that state this so users aren't thinking it's buggy behavior.

DanHaasken
Occasional Contributor

One of our ArcGIS Pro users just reported this issue to me as well and this thread helped me figure it out in less than 5 minutes so thank you all for that. We're using ArcGIS Pro 3.1.4 and it has not yet been fixed in that version. Hard to believe that this would be that difficult of a fix!?

0 Kudos
Robert_LeClair
Esri Esteemed Contributor

So I checked on BUG-000153835 and it's been fixed starting at ArcGIS 3.2.