In this Socrata module how-to we'll use the Charts module with an aggregate view to easily display a bar chart of Seattle Building Permit dollar values by permit category.

(Note that the d3.js module provides a powerful and flexible visualization alternative if appropriate for your project.)

As of April 2016, we recommend the dev version of the Charts module because it fixes a bug when using Google Charts with horizontal labels.

  1. Install the Charts module.
  2. 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.
  3. Set the Format to "chart".
  4. Set the view to use aggregation as described in Socrata how-to: Use an aggregate view to sum Seattle Building Permit values.
  5. Set the chart settings:
    1. Pick the chart type
    2. Pick Google Charts (default) or Highcharts (if installed) as the charting library
    3. Pick chart fields for the labels and data axes
    4. Set other chart settings as needed


  6. Your view should now display a chart

AttachmentSize
Chart format settings71.49 KB
Chart25.88 KB