topic Re: ArcPro not honoring selection for attribute statistics in ArcGIS Pro Questions

ArcPro not honoring selection for attribute statistics

ChristopherJStrong — Fri, 04 Nov 2022 17:11:06 GMT

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.

Re: ArcPro not honoring selection for attribute statistics

Robert_LeClair — Fri, 04 Nov 2022 19:09:03 GMT

Christopher - what ArcGIS Pro release are you using? I'm using ArcGIS Pro 3.x and have the Selection Filter on my distribution statistics as seen below. It does honor selections and shows the dataset statistics as well.

Re: ArcPro not honoring selection for attribute statistics

ChristopherJStrong — Tue, 08 Nov 2022 15:08:01 GMT

Thanks for the reply, Robert.

I'm using ArcPro 3.0.2 as well. I just tried again on a different dataset, and same issue as before. My process is to 1) open the attribute table 2) select by attributes 3) right click on the field and pick Statistics. I have tried other fields as well, with the same results.

Re: ArcPro not honoring selection for attribute statistics

Robert_LeClair — Tue, 08 Nov 2022 15:32:21 GMT

That's very odd. It seems your ArcGIS Pro 3.0.2 is missing the Selection Filter for the chart. I know this sounds strange but give it a go - close ArcGIS Pro, rename the Esri folder in your C:\users\<user_profile>\appdata\local and C:\users\<user_profile>\appdata\roaming to ESRI_OLD. Then restart ArcGIS Pro, load your data in a new Pro project and try the workflow again. Does the Selection Filter show?

Re: ArcPro not honoring selection for attribute statistics

alex_friant — Thu, 19 Jan 2023 18:09:23 GMT

I'm seeing this same issue but only with enterprise geodatabases/sde connections. If I export the EGDB feature class to a File Geodatabase, the issue goes away. I'm using ArcGIS Pro 3.0.3.

Feeling like this is a bug, because the "Selection" filter appears when the Chart is first being created and is loading the data, but as soon as the data is loaded, the button disappears. Makes no sense for the Selection filter to disappear just because the layer is in an EGDB by design.

Re: ArcPro not honoring selection for attribute statistics

alex_friant — Thu, 19 Jan 2023 18:10:59 GMT

@Robert_LeClair - Did you try creating the chart using a connection to an EGDB feature class layer? It appears the problem only happens with SDE connections.

Re: ArcPro not honoring selection for attribute statistics

ChristopherJStrong — Thu, 19 Jan 2023 19:34:07 GMT

Thanks @alex_friant. I can confirm that exporting to a file geodatabase produces the correct charts/statistics. Connecting directly to an EGDB or using an SDE connection both produce the same issue.

Re: ArcPro not honoring selection for attribute statistics

ChristopherJStrong — Thu, 19 Jan 2023 19:35:01 GMT

@Robert_LeClair I have tried renaming the ESRI directory to ESRI_OLD in both AppData directories with no change to the issue.

Re: ArcPro not honoring selection for attribute statistics

Robert_LeClair — Mon, 30 Jan 2023 17:50:08 GMT

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:

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

Re: ArcPro not honoring selection for attribute statistics

AZendel — Mon, 03 Apr 2023 17:39:08 GMT

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.

Re: ArcPro not honoring selection for attribute statistics

Robert_LeClair — Mon, 03 Apr 2023 19:41:21 GMT

@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!

Re: ArcPro not honoring selection for attribute statistics

Anonymous User — Mon, 01 May 2023 20:18:19 GMT

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

Re: ArcPro not honoring selection for attribute statistics

Anonymous User — Fri, 05 May 2023 14:26:01 GMT

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

Re: ArcPro not honoring selection for attribute statistics

CurtisTyler — Thu, 01 Jun 2023 19:17:56 GMT

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.

Re: ArcPro not honoring selection for attribute statistics

alex_friant — Fri, 02 Jun 2023 14:27:28 GMT

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

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

Re: ArcPro not honoring selection for attribute statistics

DanHaasken — Tue, 20 Feb 2024 17:37:44 GMT

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!?

Re: ArcPro not honoring selection for attribute statistics

Robert_LeClair — Thu, 22 Feb 2024 21:10:35 GMT

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

Re: ArcPro not honoring selection for attribute statistics

sbednar — Fri, 11 Apr 2025 19:46:39 GMT

Robert, this is great. Exactly what I need. However, I cannot do this with my GIS_Acre field and the "selection" option is grayed out. I do not have the option to get the max of the selected records. This seems to show the shape_length that is automatically placed in the feature class. Can you do this with an added field to the table?

Re: ArcPro not honoring selection for attribute statistics

Robert_LeClair — Tue, 15 Apr 2025 15:55:20 GMT

@sbednar - apologies for the tardy response. So I'm using a fGDB polygon feature class, added a field called GIS_Acre, calculated US Acres, selected 68 polygons, opened the attribute table, right-clicked the GIS_Acre field and selected Visualize Statistics. This creates a chart and opens the Chart Properties pane. My selection filter is not grayed out. I can click the Selection filter on/off and see the results in the chart and the statistics in the Chart Properties pane and the MAX value for the selection. I verified that the MAX selection value is correct by sort descending in the attribute table for the GIS_Acre field. I'm using ArcGIS Pro 3.4.3. See image below: