https://community.esri.com/t5/arcgis-dashboards-questions/arcgis-dashboards-stacked-bar-chart-showing/m-p/1275958#M7603 <P>You're looking to create a <EM>cumulative </EM>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?</P><P>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.</P> Wed, 05 Apr 2023 19:40:42 GMT jcarlson 2023-04-05T19:40:42Z https://community.esri.com/t5/arcgis-dashboards-questions/arcgis-dashboards-stacked-bar-chart-showing/m-p/1275939#M7602 <P>You see how in this gauge the 70% progress is shown in green vs the 100% total that is in grey?&nbsp; It looks as if the green is "covering" the grey, yes?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JosephLMonti_1-1680721111904.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/67365i6B06054BF3EB20E0/image-size/medium?v=v2&amp;px=400" role="button" title="JosephLMonti_1-1680721111904.png" alt="JosephLMonti_1-1680721111904.png" /></span></P><P>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?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JosephLMonti_0-1680721012467.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/67364i49E1957E5051F0BC/image-size/medium?v=v2&amp;px=400" role="button" title="JosephLMonti_0-1680721012467.png" alt="JosephLMonti_0-1680721012467.png" /></span></P><P>&nbsp;</P> Wed, 05 Apr 2023 19:04:40 GMT https://community.esri.com/t5/arcgis-dashboards-questions/arcgis-dashboards-stacked-bar-chart-showing/m-p/1275939#M7602 JosephLMonti 2023-04-05T19:04:40Z https://community.esri.com/t5/arcgis-dashboards-questions/arcgis-dashboards-stacked-bar-chart-showing/m-p/1275958#M7603 <P>You're looking to create a <EM>cumulative </EM>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?</P><P>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.</P> Wed, 05 Apr 2023 19:40:42 GMT https://community.esri.com/t5/arcgis-dashboards-questions/arcgis-dashboards-stacked-bar-chart-showing/m-p/1275958#M7603 jcarlson 2023-04-05T19:40:42Z