idea Allow sorting by statistic in stacked dashboard serial chart in ArcGIS Dashboards Ideas

Allow sorting by statistic in stacked dashboard serial chart

ChelseaRozek — Fri, 21 Oct 2022 17:57:01 GMT

Please allow us to sort by the statistic in the serial chart widget in ArcGIS Dashboards when stacking & splitting by a field.

As of Oct 2022 in the new Dashboards in ArcGIS Online, I cannot sort these columns so that the tallest one is first. In this example, I have category (horizontal axis) = municipality, split by (colors) = project type, and statistic (height of columns) = SUM of field "# of projects". I would like to be able to sort by the statistic so that the municipality with the greatest total # of projects" is first.

Re: Improved sorting in dashboard serial chart - Status changed to: Implemented

patrickb — Mon, 11 Apr 2022 12:48:22 GMT

There have been some recent improvements to serial charts and the ability to sort by both the category field and the split field.

https://doc.arcgis.com/en/dashboards/reference/whats-new.htm#ESRI_SECTION1_406F5580F6F34D3994D79B360CEDAA6D

Re: Improved sorting in dashboard serial chart

ChelseaRozek — Thu, 29 Sep 2022 18:11:04 GMT

Hi @patrickb , it does not look like this has been implemented and now I can no longer sort by the statistic when using "Split by Field". I'm using the new dashboards (not classic) in ArcGIS Online.

Interestingly, if I select "Split by Field" after everything is set up, "Sort by Statistic" stays. But still, this only sorts the colors within the column and not the columns themselves. Right now, I can only do that with Municipality name (the Category), so alphabetically.

Is there a way I can sort my graph so that the tallest column (most total projects) is first?

Re: Improved sorting in dashboard serial chart

Arlo — Tue, 04 Oct 2022 19:37:58 GMT

@ChelseaRozek Thanks for staying on this, I'm seeing the exact same thing.

@patrickb Perhaps the status of this idea should still be Open?

Re: Improved sorting in dashboard serial chart

patrickb — Fri, 21 Oct 2022 15:07:33 GMT

Thanks for the feedback (and apologies for the delay). When a serial chart is configured to use the split by option, the end result is a chart that has multiple categories (the categorized field) and multiple series (determined by the split by field). When displayed, the categories are displayed along the category axis and within each category there will be a data point for each series.

The improvement we made to serial chart in the split by case is that you can now (predictably) sort the series within the categories. This sorting shows up in the legend (if you choose to display it). Conceptually, we are building a dataset something like the following that can be handed off to the chart for rendering:

In previous releases, we exposed the statistic as a sorting option in the split by case. This was actually a bug/oversight in our testing, and not in harmony with the chart we had envisioned and spec'd out. Selecting that config option did not (predictably) affect the chart that got rendered, and this explains why it was removed. Unfortunately, your observation that "if I select "Split by Field" after everything is set up, "Sort by Statistic" stays ... is another oversight in our testing.

With the above in mind, your use case for sorting data points based on their calculated statistic within each category might make sense for some workflows. For that, I would suggest submitting a new idea for the community to vote on. It would have a descriptive title, and perhaps some quick mockup diagrams of the desired chart. (I can re-open this idea, but cannot change the title. With the current title, the idea was not gaining much traction).

Re: Allow sorting by statistic in stacked dashboard serial chart

ChelseaRozek — Fri, 21 Oct 2022 17:57:42 GMT

Hi @patrickb, thanks for the insight and feedback! I agree my idea was confusing. I've remade the title and description to clarify. If you think it's ok now, would you mind reopening the idea?

Re: Allow sorting by statistic in stacked dashboard serial chart - Status changed to: Open

patrickb — Fri, 21 Oct 2022 18:07:39 GMT

Re: Allow sorting by statistic in stacked dashboard serial chart

SAldrich_ingov — Wed, 28 Jun 2023 15:49:03 GMT

I logged exactly this issue as a bug. ESRI states that this is a "known limitation" and though their documentation and promotional materials mention this capability as an option, it has not been implemented.

This is an "enhancement" request now, and "might" get addressed in a future AGOL release.

Re: Allow sorting by statistic in stacked dashboard serial chart

CourtneyPesak — Fri, 10 Jan 2025 17:59:47 GMT

I am also looking for this enhancement. I have a serial chart that is grouped by a value that has over 100 records.
I need to be able to sort by the largest bar on the left and smallest on the right as I have to incorporate a slider since there are so many on the Category axis