topic Column Chart Question ArcGIS Dashboard in ArcGIS Dashboards Questions https://community.esri.com/t5/arcgis-dashboards-questions/column-chart-question-arcgis-dashboard/m-p/1378514#M9026 <P>Hi,</P><P>I have a dataset containing ages ranging from 6 to 17 years in each column (as shown in the example below). I am attempting to categorize these age groups into the following new groups and visualize them in a column chart, displaying the sum of each age group by Sport Club Name:</P><UL><LI>Age 6-8</LI><LI>Age 9-10</LI><LI>Age 11-13</LI><LI>Age 14-17</LI></UL><P>Could someone please provide some assistance?</P><TABLE border="1" width="100%"><TBODY><TR><TD width="10%" height="69px">Sport Club Name</TD><TD width="10%" height="69px">Age 6</TD><TD width="9.746514575411913%" height="69px">Age 7</TD><TD width="10.253485424588087%" height="69px">Age 8</TD><TD width="10%" height="69px">Age 9</TD><TD width="10%" height="69px">Age 10</TD><TD width="10%" height="69px">Age 11</TD><TD width="10%" height="69px">Age 12</TD><TD width="10%" height="69px">Age 13</TD><TD width="10%" height="69px">Age 14</TD></TR><TR><TD width="10%" height="25px">A</TD><TD width="10%" height="25px">1</TD><TD width="9.746514575411913%" height="25px">1</TD><TD width="10.253485424588087%" height="25px">6</TD><TD width="10%" height="25px">23</TD><TD width="10%" height="25px">34</TD><TD width="10%" height="25px">11</TD><TD width="10%" height="25px">16</TD><TD width="10%" height="25px">34</TD><TD width="10%" height="25px">12</TD></TR><TR><TD width="10%" height="25px">B</TD><TD width="10%" height="25px">2</TD><TD width="9.746514575411913%" height="25px">3</TD><TD width="10.253485424588087%" height="25px">6</TD><TD width="10%" height="25px">12</TD><TD width="10%" height="25px">32</TD><TD width="10%" height="25px">15</TD><TD width="10%" height="25px">12</TD><TD width="10%" height="25px">34</TD><TD width="10%" height="25px">56</TD></TR><TR><TD width="10%" height="25px">C</TD><TD width="10%" height="25px">1</TD><TD width="9.746514575411913%" height="25px">4</TD><TD width="10.253485424588087%" height="25px">7</TD><TD width="10%" height="25px">1</TD><TD width="10%" height="25px">21</TD><TD width="10%" height="25px">30</TD><TD width="10%" height="25px">17</TD><TD width="10%" height="25px">56</TD><TD width="10%" height="25px">23</TD></TR><TR><TD width="10%" height="25px">D</TD><TD width="10%" height="25px">5</TD><TD width="9.746514575411913%" height="25px">5</TD><TD width="10.253485424588087%" height="25px">8</TD><TD width="10%" height="25px">33</TD><TD width="10%" height="25px">12</TD><TD width="10%" height="25px">12</TD><TD width="10%" height="25px">56</TD><TD width="10%" height="25px">12</TD><TD width="10%" height="25px">12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks</P> Tue, 06 Feb 2024 21:47:33 GMT Calvin_ESRI_User 2024-02-06T21:47:33Z Column Chart Question ArcGIS Dashboard https://community.esri.com/t5/arcgis-dashboards-questions/column-chart-question-arcgis-dashboard/m-p/1378514#M9026 <P>Hi,</P><P>I have a dataset containing ages ranging from 6 to 17 years in each column (as shown in the example below). I am attempting to categorize these age groups into the following new groups and visualize them in a column chart, displaying the sum of each age group by Sport Club Name:</P><UL><LI>Age 6-8</LI><LI>Age 9-10</LI><LI>Age 11-13</LI><LI>Age 14-17</LI></UL><P>Could someone please provide some assistance?</P><TABLE border="1" width="100%"><TBODY><TR><TD width="10%" height="69px">Sport Club Name</TD><TD width="10%" height="69px">Age 6</TD><TD width="9.746514575411913%" height="69px">Age 7</TD><TD width="10.253485424588087%" height="69px">Age 8</TD><TD width="10%" height="69px">Age 9</TD><TD width="10%" height="69px">Age 10</TD><TD width="10%" height="69px">Age 11</TD><TD width="10%" height="69px">Age 12</TD><TD width="10%" height="69px">Age 13</TD><TD width="10%" height="69px">Age 14</TD></TR><TR><TD width="10%" height="25px">A</TD><TD width="10%" height="25px">1</TD><TD width="9.746514575411913%" height="25px">1</TD><TD width="10.253485424588087%" height="25px">6</TD><TD width="10%" height="25px">23</TD><TD width="10%" height="25px">34</TD><TD width="10%" height="25px">11</TD><TD width="10%" height="25px">16</TD><TD width="10%" height="25px">34</TD><TD width="10%" height="25px">12</TD></TR><TR><TD width="10%" height="25px">B</TD><TD width="10%" height="25px">2</TD><TD width="9.746514575411913%" height="25px">3</TD><TD width="10.253485424588087%" height="25px">6</TD><TD width="10%" height="25px">12</TD><TD width="10%" height="25px">32</TD><TD width="10%" height="25px">15</TD><TD width="10%" height="25px">12</TD><TD width="10%" height="25px">34</TD><TD width="10%" height="25px">56</TD></TR><TR><TD width="10%" height="25px">C</TD><TD width="10%" height="25px">1</TD><TD width="9.746514575411913%" height="25px">4</TD><TD width="10.253485424588087%" height="25px">7</TD><TD width="10%" height="25px">1</TD><TD width="10%" height="25px">21</TD><TD width="10%" height="25px">30</TD><TD width="10%" height="25px">17</TD><TD width="10%" height="25px">56</TD><TD width="10%" height="25px">23</TD></TR><TR><TD width="10%" height="25px">D</TD><TD width="10%" height="25px">5</TD><TD width="9.746514575411913%" height="25px">5</TD><TD width="10.253485424588087%" height="25px">8</TD><TD width="10%" height="25px">33</TD><TD width="10%" height="25px">12</TD><TD width="10%" height="25px">12</TD><TD width="10%" height="25px">56</TD><TD width="10%" height="25px">12</TD><TD width="10%" height="25px">12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks</P> Tue, 06 Feb 2024 21:47:33 GMT https://community.esri.com/t5/arcgis-dashboards-questions/column-chart-question-arcgis-dashboard/m-p/1378514#M9026 Calvin_ESRI_User 2024-02-06T21:47:33Z