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

1577
9
Jump to solution
12-09-2016 03:51 AM
AbdulazizAl_yahya
New Contributor II

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

0 Kudos
1 Solution

Accepted Solutions
AbdullahAnter
Occasional Contributor III

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 )

View solution in original post

9 Replies
AbdullahAnter
Occasional Contributor III

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

0 Kudos
AbdulazizAl_yahya
New Contributor II

advanced 

0 Kudos
AbdullahAnter
Occasional Contributor III

I think that you can do that using ArcGIS desktop

0 Kudos
AbdullahAnter
Occasional Contributor III

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
New Contributor II

does these methods work for related tables or just layers ?

0 Kudos
AbdullahAnter
Occasional Contributor III

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

0 Kudos
AbdulazizAl_yahya
New Contributor II

one to many relationship class

0 Kudos
AbdullahAnter
Occasional Contributor III

Good, create new table using summarize statistics

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

0 Kudos
AbdulazizAl_yahya
New Contributor II

Many thanks , that helped a lot