ArcPro not honoring selection for attribute statistics

4932
18
11-04-2022 10:11 AM
Labels (1)
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

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

ChristopherJStrong
Occasional Contributor

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.

Robert_LeClair
Esri Esteemed Contributor

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?

alex_friant
Frequent Contributor

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

ChristopherJStrong
Occasional Contributor

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

sbednar
New Contributor

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? 

0 Kudos
Robert_LeClair
Esri Esteemed Contributor

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

Chart_Selection_Statistics.JPG

0 Kudos
alex_friant
Frequent Contributor

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.

ChristopherJStrong
Occasional Contributor

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.