AnsweredAssumed Answered

how to get average,max and min from related table on column

Question asked by is499project on Dec 9, 2016
Latest reply on Dec 10, 2016 by is499project

First, I have no experience in GIS.

 

I'm using ArcGis desktop and ArcGis web app builder.

 

I have a layer for neighborhoods and I have a table which is related to neighborhood layer and it have records for transactions of parcels that have been sold inside the neighborhood, the transaction table store these data : 

 

neighborhoodID,transactionPrice and pricePerMeter .

 

I will give an example and please help me how to this .

 

Neighborhood with ID =1 , the user click on it just like Related Table Charts widget to show charts.

 

I want these chart to calculate the average for all transactionPrice that belongs to neighborhoodID =1 and so on with other operations (avg,max,min..)

 

I used Related Table Charts widget , it's useless for my case because there is no operation to do on the data.

 

How to do this ? is there widget for it ? can Arcgis Desktop do it ? please any thing that might help me

Outcomes