The Chart Builder in Crash Query is designed to help users create custom downloadable charts to visualize the data contained in a Query. Each custom chart can utilize either the Crash Cost Measure, which uses your agencies default KABCO cost calculations to determine the cost of the crashes for each grouping, or the Crash Count Measure which calculates the total number of crashes for each grouping.

Charts are saved with any Query, and can be easily referenced or downloaded from previously saved Crash Queries.

Chart Types

There are six chart types available in the Chart Builder: Bar, Stacked Bar, Grouped Bar, Line, Pie, and Pivot Table.

Bar

The Bar Chart allows users to visualize a measure and a single grouping in a vertical bar chart.

The Bar Chart is downloadable as a PNG image file.

Stacked Bar

The Stacked Bar Chart allows users to visualize a measure and two groupings in a stacked vertical bar chart. The Stacked Bar Chart is downloadable as a PNG image file.

Grouped Bar

The Grouped Bar Chart allows users to visualize a measure and two groupings in a vertical grouped bar chart. The Grouped Bar Chart is downloadable as a PNG image file.

Line

The Line Chart allows users to visualize a measure and a single grouping in a vertical line chart. The Line Chart is downloadable as a PNG image file.

Pie

The Pie Chart allows users to visualize a measure and a single grouping in a pie chart. The Pie Chart is downloadable as a PNG image file.

Pivot Table

The Pivot Table chart allows users to visualize a measure, and up to three groupings in a Pivot Table. The Pivot Table is downloadable as a CSV file.

When creating a Pivot Table, the first grouping will define the rows of the table, the second grouping will define the columns, and the third grouping will define a second row. In the example below, the first grouping is by year, the second grouping is by city, and the third grouping is by bicyclist involved.

Chart Builder Sidebar

When creating a custom chart, the chart builder sidebar contains various formatting adjustments and customizations that can be applied to each chart. The Chart Builder Sidebar contains the following headings:

Sorting

Under the Sorting heading, users can adjust the order in which the values in their chart appear, either ascending, or descending. 

Users can also determine if the sorting should be applied to the measure or the grouping.

The number of values to be displayed can be selected using the text entry box. This will display the top identified number of values that meet the sorting criteria. The Bar, Stacked Bar, Grouped Bar, and Line Chart types can all display a maximum of 50 values, the Pie Chart can display a maximum of 15 values.

In the Pie Chart, users can also select to include an “Other” slicer, which will include all other values not visualized in the pie chart as a slice labeled “Other”.

Available for the following Chart Types: Bar, Stacked Bar, Grouped Bar, Line, Pie.

Vertical and Horizontal Axis

The Vertical and Horizontal Axis headings allow users to add a custom title to either axis. This custom text will appear along the outside of either the vertical, or horizontal axis in the chart.

Additionally, users can check the Show tick Labels box, which will display label values along the horizontal or vertical axis. The formatting of the tick labels can be customized by clicking on the gear icon to the right of the checkbox. This will allow users to add a prefix/suffix, or change the number or date/time formatting of the labels.

Available for the following Chart Types: Bar, Stacked Bar, Grouped Bar, Line. 

Legend

Under the Legend heading, users can select the location of the legend on the chart. Users can select between the bottom, or left side of the chart.

Available for the following Chart Types: Stacked Bar, Grouped Bar, Pie.

Totals

Under the Totals heading, users can select if they would like a “Total” row, or “Total” column to appear in their custom pivot table. Toggling either of these boxes will show or hide a column or row totaling all the values contained in the corresponding column or row.

Available for the following Chart Types: Pivot Table.

Did this answer your question?