In this Socrata module how-to we'll create an aggregate view to easily display a table of Seattle Building Permit dollar values by permit category.

• Seattle Building Permit endpoint: https://data.seattle.gov/resource/i5jq-ms7b.json

1. Create a Socrata endpoint and view as described in the Socrata module documentation. In this case, we'll use the Seattle Building Permits endpoint above.
2. Add the following fields to your view: "Seattle Building Permit Data: Category" (the category name for the permits) and "Seattle Building Permit Data: Value" (the dollar value for the permits) .
3. Under Advanced -> Other, turn on aggregation for the view.
   
   
4. For the Value field, click the "Aggregation settings" and change the "Aggregation type" to Sum. (The other "Aggregation type" values of Count, Average, Minimum or Maximum will be useful in other views you may create for other cases.)
   
   
   
   
5. Now your view will aggregate the results, summing the permit values by permit category.