https://community.esri.com/t5/arcgis-experience-builder-ideas/make-a-chart-based-on-a-category-group-and-a-value/idi-p/1287349 <P>I would like to make a chart based on a type category and a value category.&nbsp; That is to say that the statistics are based on a summation of another field and not just the number of rows.</P><TABLE border="1" width="100%"><TBODY><TR><TD width="50%"><STRONG>Category</STRONG></TD><TD width="50%"><STRONG>Value</STRONG></TD></TR><TR><TD width="50%">x</TD><TD width="50%">15</TD></TR><TR><TD width="50%">y</TD><TD width="50%">12</TD></TR><TR><TD width="50%">z</TD><TD width="50%">36</TD></TR><TR><TD width="50%">x</TD><TD width="50%">12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to make a chart that sums the category by value. For example x would be 27 since it is in the table twice with values of 12 and 15.</P><P>&nbsp;</P> Tue, 09 May 2023 17:18:08 GMT mklatt_cityofventura_ca_gov 2023-05-09T17:18:08Z https://community.esri.com/t5/arcgis-experience-builder-ideas/make-a-chart-based-on-a-category-group-and-a-value/idi-p/1287349 <P>I would like to make a chart based on a type category and a value category.&nbsp; That is to say that the statistics are based on a summation of another field and not just the number of rows.</P><TABLE border="1" width="100%"><TBODY><TR><TD width="50%"><STRONG>Category</STRONG></TD><TD width="50%"><STRONG>Value</STRONG></TD></TR><TR><TD width="50%">x</TD><TD width="50%">15</TD></TR><TR><TD width="50%">y</TD><TD width="50%">12</TD></TR><TR><TD width="50%">z</TD><TD width="50%">36</TD></TR><TR><TD width="50%">x</TD><TD width="50%">12</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to make a chart that sums the category by value. For example x would be 27 since it is in the table twice with values of 12 and 15.</P><P>&nbsp;</P> Tue, 09 May 2023 17:18:08 GMT https://community.esri.com/t5/arcgis-experience-builder-ideas/make-a-chart-based-on-a-category-group-and-a-value/idi-p/1287349 mklatt_cityofventura_ca_gov 2023-05-09T17:18:08Z https://community.esri.com/t5/arcgis-experience-builder-ideas/make-a-chart-based-on-a-category-group-and-a-value/idc-p/1296532#M1445 <P>This is possible already.&nbsp; Change the statistic to SUM.</P><P>then you can choose the number field to sum on.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mklatt_cityofventura_ca_gov_0-1686094665101.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/72514iDFA7193DBA464B7C/image-size/medium?v=v2&amp;px=400" role="button" title="mklatt_cityofventura_ca_gov_0-1686094665101.png" alt="mklatt_cityofventura_ca_gov_0-1686094665101.png" /></span></P><P>&nbsp;</P> Tue, 06 Jun 2023 23:37:51 GMT https://community.esri.com/t5/arcgis-experience-builder-ideas/make-a-chart-based-on-a-category-group-and-a-value/idc-p/1296532#M1445 mklatt_cityofventura_ca_gov 2023-06-06T23:37:51Z