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

[AbdulazizAl_yahya]

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

[AbdullahAnter]

Which license do you have ? (basic, standard or Advanced )

[AbdulazizAl_yahya]

advanced 

[AbdullahAnter]

I think that you can do that using ArcGIS desktop

[AbdullahAnter · Accepted solution]

Frist you will create relationship between neighborhoods layer and related table ( Relationships and ArcGIS )

Then you will summarize fields to get maximum, minimum and average

( Summarizing data in a table )

( Summary Statistics )

[AbdulazizAl_yahya]

does these methods work for related tables or just layers ?

[AbdullahAnter]

what kind of relationship ? one to one or one to many ?

[AbdulazizAl_yahya]

one to many relationship class

[AbdullahAnter]

Good, create new table using summarize statistics

( Summary Statistics ), then make a relationship with a new table

[AbdulazizAl_yahya]

Many thanks , that helped a lot