idea Chart Properties: use selection statistics column to give selection statistics in ArcGIS Pro Ideas

Chart Properties: use selection statistics column to give selection statistics

wayfaringrob — Wed, 27 Jul 2022 16:21:52 GMT

When making a selection with a chart open, a column called 'Selection' appears in Chart Properties. I would think that it would display statistics for your selected features whereas the 'Dataset' column would show stats for the entire dataset. However, with a selection, the 'Selection' column seems to show the same thing as the 'Dataset' column. It would make more sense if the 'Selection' column actually reflected your selection.

In the below example, I select 553 features. The selection column appears and populates statistics for 698 features, which is the entire dataset.

(view in My Videos)

Re: Chart Properties: use selection statistics column to give selection statistics - Status changed to: Needs Clarification

AmeliaBradshaw — Wed, 27 Jul 2022 16:41:21 GMT

Hello @wayfaringrob ,

Thank you for posting this Idea! What you demonstrate here should be possible while interacting with a chart, with a few exceptions. The 'Selection' section of the 'Interact with a chart' documentation states that a selection made in the map should be reflected in the chart, and vice versa. There is an exception for this, based on data source:

"When data comes from an enterprise database or cloud data warehouse source, selection is not available for bar charts, line charts, histograms, and scatter plots."

Are you currently working with data housed in an enterprise geodatabase or a cloud data warehouse? If not, where is the data housed?

Thank you,

Amelia

Re: Chart Properties: use selection statistics column to give selection statistics

wayfaringrob — Wed, 27 Jul 2022 16:42:16 GMT

@AmeliaBradshaw this is from LA.

Re: Chart Properties: use selection statistics column to give selection statistics

wayfaringrob — Wed, 27 Jul 2022 16:50:44 GMT

Also, what you're saying about data source isn't totally true, as selection-based statistics are available within Data Engineering.

It gets really confusing when opening these charts outside of the DE view - again, the charts within the DE table show statistics based on the selection, but when popping the chart out, they revert to the whole layer with no indication that this is the case. For an area of the application aimed at empowering users to ensure data integrity, this is really alarming. There should at least be some kind of warning that despite making a selection and seeing the selection reflected in DE, clicking the 'Selection' filter in the chart, and having a 'Selection' column, you are not working with your selection once you leave DE.

If Pro can produce statistics from the selection within data engineering, then why is this not enabled in the rest of the application?

Re: Chart Properties: use selection statistics column to give selection statistics

AmeliaBradshaw — Wed, 27 Jul 2022 16:55:53 GMT

@wayfaringrob when you state 'From LA', what do you mean? LA as in Los Angeles, or does the acronym stand for something else?

Yes, I have seen that with Data Engineering, but from what we state in the documentation, the selection should be honored in charts as well. Let me double check on this and see if this behavior is expected.

Re: Chart Properties: use selection statistics column to give selection statistics

wayfaringrob — Wed, 27 Jul 2022 17:00:15 GMT

@AmeliaBradshaw Living Atlas.

Re: Chart Properties: use selection statistics column to give selection statistics

AmeliaBradshaw — Wed, 27 Jul 2022 17:14:00 GMT

Perfect, thank you for clarifying @wayfaringrob ! Let me check to see if this works with Living Atlas data, but I think it should.

One thing I noticed when testing this on my side. After the selection is chosen in the map, I still need to press 'Selection' next to 'Filter' in the Chart itself. This is located at the top of the chart pane when open in Pro. The video below shows this result with some local file geodatabase data:

(view in My Videos)

This should modify the chart to show just the selected features in the bar chart.

Re: Chart Properties: use selection statistics column to give selection statistics

ChristopherAllen — Wed, 10 Aug 2022 18:51:03 GMT

Hi @wayfaringrob ,

Thanks for the feedback. The "Selection" column in the histogram statistics panel should calculate and display statistics for the selected features, but unfortunately it appears that this is not the case in your examples. As @AmeliaBradshaw mentioned, the exception would be if the data comes from an enterprise database or cloud data warehouse source, but selection should still work as expected with a feature service.

I tried using steps that are similar to your video (with a layer from Living Atlas) and could not reproduce the issue. The selection statistics for the histogram appear to match what is displayed in Data Engineering:

We might be able to diagnose if you are able to share your dataset and/or project with us (which you can email to callen@esri.com).

Thanks!

Chris

Re: Chart Properties: use selection statistics column to give selection statistics

LanceKirby2 — Fri, 21 Oct 2022 16:11:10 GMT

What version of ArcGIS Pro are you using? I am using 3.02 and no longer get the statistics section in the chart properties panel. @ChristopherAllen. Is this intended?

Re: Chart Properties: use selection statistics column to give selection statistics

ChristopherAllen — Sat, 22 Oct 2022 00:45:24 GMT

Hi @LanceKirby2

I checked on Pro 3.0.2 and am seeing the statistics section populated in the Chart Properties pane for histograms:

I tried with a variety of data sources (shapefile, file geodatabase, enterprise geodatabase, CSV) and the statistics were displaying in all cases.

A few questions that might help us investigate the problem:

Would it be possible to share a screenshot of the Chart Properties with the missing statistics?
Are the statistics missing from all histograms, or does it display for some? If it displays for some, is there anything different about the dataset where the statistics are not displaying?
It sounds like the statistics were working for you in a previous version of Pro. Do you know in which version it was last working?
Would it be possible to share a project or dataset where you encountered the issue? If that's possible, feel free to email me at callen@esri.com.

Answers to any of these would be much appreciated. Feel free to respond here or reach out to me through email (callen@esri.com). Thanks!

Re: Chart Properties: use selection statistics column to give selection statistics

LanceKirby2 — Mon, 24 Oct 2022 14:42:15 GMT

@ChristopherAllen thanks for the reply. In the chart properties the Data tab was not showing when I initially posted. After restarting ArcGIS Pro it is now displaying so that issue seems to be resolved. I do want to mention that the statistics in the chart pane do not reflect my selection of features within the attribute table. I see that you mentioned this expected behavior with a feature class from an enterprise geodatabase, but I feel like this worked at previous versions of ArcGIS Pro. Is this a new implementation? Is there any road map to make this work with enterprise geodatabase feature classes? With a high amount of users using enterprise geodatabases this feature seems like a worth while addition.

Re: Chart Properties: use selection statistics column to give selection statistics

ChristopherAllen — Mon, 24 Oct 2022 19:25:44 GMT

Hi @LanceKirby2

Thank you for responding--glad to hear that the statistics are still being show in the Data tab!

The performance enhancements for charts using data from a cloud data warehouse or enterprise database were introduced in the 3.0 release (see the documentation page for more details). Unfortunately, one limitation of these performance enhancements is that chart selection is no longer supported. Currently, we allow you to disable the performance enhancements (thus allowing for chart selection) by setting a registry key, as described in the following technical article:

https://support.esri.com/en/technical-article/000027747

Please let me know if you have any additional questions.

Thanks!

Chris

Re: Chart Properties: use selection statistics column to give selection statistics

ChristopherAllen — Mon, 11 Aug 2025 20:47:33 GMT

Hi all, I'm closing this because we have not been able to reproduce the original bug where the selection statistics are displaying the same values as the entire dataset.

I also wanted to mention that starting in Pro 3.2, server-side processing is turned off by default, so chart selection and selection statistics should be available automatically when the data comes from a cloud data warehouse or enterprise database. We also introduced a toggle in the Chart Properties pane to facilitate turning this setting on/off:

Thanks,

Chris

Re: Chart Properties: use selection statistics column to give selection statistics - Status changed to: Closed

ChristopherAllen — Mon, 11 Aug 2025 20:47:46 GMT