Select to view content in your preferred language

ArcGIS Dashboards - Stacked Bar Chart Showing Progress in a different color

433
1
04-05-2023 12:04 PM
JosephLMonti
New Contributor

You see how in this gauge the 70% progress is shown in green vs the 100% total that is in grey?  It looks as if the green is "covering" the grey, yes?

JosephLMonti_1-1680721111904.png

How can I do this in a bar chart like this image below, where orange is the total and blue is the percent completed so far?

JosephLMonti_0-1680721012467.png

 

0 Kudos
1 Reply
jcarlson
MVP Esteemed Contributor

You're looking to create a cumulative series in your chart, it sounds like? It might depend on the data. Where is the blue/orange chart coming from? Is there a "% completed" field in your data already?

There's no built-in way to do this that I'm aware of, but you could accomplish it with a Data Expression. You'd need to iterate over each feature and calculate the % of the total based on all preceding values. Depending on the number of values in the table, it could take a while to calculate, but it wouldn't need to be terribly complicated.

- Josh Carlson
Kendall County GIS
0 Kudos