topic Re: ArcGIS Experience Builder Stacked Bar Charts in ArcGIS Experience Builder Questions

ArcGIS Experience Builder Stacked Bar Charts

LJackson29 — Thu, 04 Nov 2021 18:42:44 GMT

I am new to Experience Builder and trying to create a stacked chart, but I do not see an option to select a second attribute to split by. I am using it in ArcGIS online. Can someone point me in the right direction. I also see that there is the option to see counts when you hover over a column, but don't see where to turn that one. Many thanks!

Re: ArcGIS Experience Builder Stacked Bar Charts

ZacharyVavra — Mon, 08 Nov 2021 14:39:47 GMT

I was wondering the same thing!

Re: ArcGIS Experience Builder Stacked Bar Charts

GeorgeF — Wed, 20 Apr 2022 12:41:13 GMT

Likewise. Any advice?

Re: ArcGIS Experience Builder Stacked Bar Charts

LJackson29 — Wed, 20 Apr 2022 12:46:10 GMT

I haven't tried this again lately, but resorted to creating my dashboard in ArcGIS dashboard and embedded it in my Experience Builder app that has several other tabs for editing and viewing data.

Re: ArcGIS Experience Builder Stacked Bar Charts

DorothyShreve — Fri, 12 Aug 2022 19:13:23 GMT

I am also curious if this can be done. The icons indicate that stacked charts are possible, but there's no place to define a group to split the stacks on.

Re: ArcGIS Experience Builder Stacked Bar Charts

SWalkerCDD — Fri, 09 Sep 2022 16:08:44 GMT

Yes, it is odd that both the chart icons and the help page for the Experience Builder chart widget show grouped stacked bar charts, but it doesn't seem like it's actually possible to create them. It would be nice to get a response from ESRI on this pretty basic functionality and the misleading representation of capabilities (or clear instructions on how to actually do it if it is possible).

https://doc.arcgis.com/en/experience-builder/latest/configure-widgets/chart-widget.htm

Re: ArcGIS Experience Builder Stacked Bar Charts

pamela_king — Wed, 28 Dec 2022 17:09:28 GMT

I am in the same situation with wanting to split by attribute. I am probably also going to just use dashboard and embed it, but really wish this would just get updated in Experience.

I did see where you can can the value labels at the top of the bars under the "Series" tab.

Re: ArcGIS Experience Builder Stacked Bar Charts

Kristen — Wed, 28 Dec 2022 18:14:41 GMT

You can do it but your data has to be formatted in a very specific way. So for the example on this page , the state is a text field and you would choose that as the category field. Then for your statistic, you cannot choose count, you have to pick sum or some other statistic. Then you will get a drop down to choose a number field and the ones you check will be the different color bars. The fields you want to be different colors must be numeric. So if I wanted to count text categories in each state (e.g. 'High', 'Medium', 'Low') I would need to create new columns for High, Medium, and Low and assign the values 1 for True and 0 for False. Then I could get the sum of each column (High, Medium, and Low) and display them as different colored bar for each state.

Re: ArcGIS Experience Builder Stacked Bar Charts

GerberMatthew — Tue, 13 Jun 2023 03:43:03 GMT

Thats a seriously limiting way of run stacked chart statistics.

Usual data records have a single value, but your stacking is based on another category field.

Eg. Say you have a road line dataset and wanted to stack length of road based on road type for different states. You want your X axis to be "State", your Y being sun of "Length" and your stacked categories to be type.

@ESRI (or anyone else) how would I tackle this pivoting of data?

Re: ArcGIS Experience Builder Stacked Bar Charts

Sarah_of_Lubbock — Wed, 06 Sep 2023 16:40:31 GMT

There is an idea out there on this issue - if y'all wanna jump on and thumb it up.
https://community.esri.com/t5/arcgis-experience-builder-ideas/arcgis-experience-builder-quot-stacked-bar-charts/idc-p/1325992#M1710