topic how to get average,max and min from related table on column in ArcGIS Mapping and Charting Questions https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608859#M2104 <HTML><HEAD></HEAD><BODY><P>First, I have no experience in GIS.</P><P></P><P>I'm using ArcGis desktop and ArcGis web app builder.</P><P></P><P>I have a layer for&nbsp;neighborhoods and I have a table which is related to&nbsp;neighborhood layer and it have records for transactions of parcels that have been sold&nbsp;inside the neighborhood, the transaction table store these data :&nbsp;</P><P></P><P>neighborhoodID,transactionPrice and pricePerMeter .</P><P></P><P>I will give an example and please help me how to this .</P><P></P><P>Neighborhood with ID =1 , the user click on it just like Related Table Charts widget to show charts.</P><P></P><P>I want these chart to calculate the average for all&nbsp;transactionPrice that belongs to neighborhoodID =1 and so on with other operations (avg,max,min..)</P><P></P><P>I used&nbsp;Related Table Charts widget , it's useless for my case because there is no operation to do on the data.</P><P></P><P>How to do this ? is there&nbsp;widget for it ? can Arcgis Desktop do it ? please any thing that might help me</P></BODY></HTML> Fri, 09 Dec 2016 11:51:27 GMT AbdulazizAl_yahya 2016-12-09T11:51:27Z how to get average,max and min from related table on column https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608859#M2104 <HTML><HEAD></HEAD><BODY><P>First, I have no experience in GIS.</P><P></P><P>I'm using ArcGis desktop and ArcGis web app builder.</P><P></P><P>I have a layer for&nbsp;neighborhoods and I have a table which is related to&nbsp;neighborhood layer and it have records for transactions of parcels that have been sold&nbsp;inside the neighborhood, the transaction table store these data :&nbsp;</P><P></P><P>neighborhoodID,transactionPrice and pricePerMeter .</P><P></P><P>I will give an example and please help me how to this .</P><P></P><P>Neighborhood with ID =1 , the user click on it just like Related Table Charts widget to show charts.</P><P></P><P>I want these chart to calculate the average for all&nbsp;transactionPrice that belongs to neighborhoodID =1 and so on with other operations (avg,max,min..)</P><P></P><P>I used&nbsp;Related Table Charts widget , it's useless for my case because there is no operation to do on the data.</P><P></P><P>How to do this ? is there&nbsp;widget for it ? can Arcgis Desktop do it ? please any thing that might help me</P></BODY></HTML> Fri, 09 Dec 2016 11:51:27 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608859#M2104 AbdulazizAl_yahya 2016-12-09T11:51:27Z Re: how to get average,max and min from related table on column https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608860#M2105 <HTML><HEAD></HEAD><BODY><P>Which license do you have ? (basic, standard or Advanced )</P></BODY></HTML> Fri, 09 Dec 2016 13:53:48 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608860#M2105 AbdullahAnter 2016-12-09T13:53:48Z Re: how to get average,max and min from related table on column https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608861#M2106 <HTML><HEAD></HEAD><BODY><P><SPAN style="background-color: #ffffff;">advanced&nbsp;</SPAN></P></BODY></HTML> Fri, 09 Dec 2016 16:27:45 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608861#M2106 AbdulazizAl_yahya 2016-12-09T16:27:45Z Re: how to get average,max and min from related table on column https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608862#M2107 <HTML><HEAD></HEAD><BODY><P>I think that you can do that using ArcGIS desktop</P></BODY></HTML> Fri, 09 Dec 2016 17:27:14 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608862#M2107 AbdullahAnter 2016-12-09T17:27:14Z Re: how to get average,max and min from related table on column https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608863#M2108 <HTML><HEAD></HEAD><BODY><P>Frist you will create relationship between neighborhoods layer and related table (&nbsp;<A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/relationships/relationships-and-arcgis.htm">Relationships and ArcGIS</A> )</P><P>Then you will summarize fields to get maximum, minimum and average</P><P>(&nbsp;<A href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/summarizing-data-in-a-table.htm">Summarizing data in a table</A> )</P><P>(&nbsp;<A href="http://desktop.arcgis.com/en/arcmap/latest/tools/analysis-toolbox/summary-statistics.htm">Summary Statistics</A> )</P></BODY></HTML> Fri, 09 Dec 2016 17:35:44 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608863#M2108 AbdullahAnter 2016-12-09T17:35:44Z Re: how to get average,max and min from related table on column https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608864#M2109 <HTML><HEAD></HEAD><BODY><P>does these methods work for related tables or just layers ?</P></BODY></HTML> Fri, 09 Dec 2016 17:39:07 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608864#M2109 AbdulazizAl_yahya 2016-12-09T17:39:07Z Re: how to get average,max and min from related table on column https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608865#M2110 <HTML><HEAD></HEAD><BODY><P>what kind of relationship ? one to one or one to many ?</P></BODY></HTML> Fri, 09 Dec 2016 18:02:30 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608865#M2110 AbdullahAnter 2016-12-09T18:02:30Z Re: how to get average,max and min from related table on column https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608866#M2111 <HTML><HEAD></HEAD><BODY><P>one to many relationship class</P></BODY></HTML> Fri, 09 Dec 2016 18:38:51 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608866#M2111 AbdulazizAl_yahya 2016-12-09T18:38:51Z Re: how to get average,max and min from related table on column https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608867#M2112 <HTML><HEAD></HEAD><BODY><P>Good, create new table using summarize statistics</P><P>(&nbsp;<A href="https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fdesktop.arcgis.com%2Fen%2Farcmap%2Flatest%2Ftools%2Fanalysis-toolbox%2Fsummary-statistics.htm" rel="nofollow" target="_blank"><SPAN style="color: #287433;">Summary Statistics</SPAN></A> ), then make a relationship with a new table</P></BODY></HTML> Fri, 09 Dec 2016 18:43:18 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608867#M2112 AbdullahAnter 2016-12-09T18:43:18Z Re: how to get average,max and min from related table on column https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608868#M2113 <HTML><HEAD></HEAD><BODY><P>Many thanks , that helped a lot&nbsp;</P></BODY></HTML> Sat, 10 Dec 2016 12:04:05 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/how-to-get-average-max-and-min-from-related-table/m-p/608868#M2113 AbdulazizAl_yahya 2016-12-10T12:04:05Z