.png)
Interacting with the Crash Tabulation and Charting Application
The Crash Tabulation and Charting Application is a single page application that allows you to examine many different dimensions of the crash data. The data is available in three different levels including at the Crash level, the Vehicle level, and the Person level. Within each are numerous attributes with which you can pivot the data.
Key workflows for interacting with the application includes:
üCustomizing the Chart, Field Format, and Layout
üSaving the Report Configuration
Pivoting the data is the most complex part of the workflow. To work with the data first decide on what level of data you would like to explore. You can choose Crash, Vehicle, or Person level data. Each has its own suite of attributes for examining. To select a level of data simply click on the corresponding tab.
.png)
Once the data level is selected for the desired report, you can then start pivoting the available data using the Fields dialog. The Fields dialog is made up of two areas - the Fields Chooser area and the Pivot Configuration area.
.png)
The field chooser contains Attributes of the selected data level as well as Measures.
.png)
To begin pivoting the data click and drag a Measure to the Values section or simply click the box to have it moved there automatically.
.png)
To select an Attribute, click and drag an attribute to the Columns or Rows box as desired.
.png)
Once a Measure and an Attribute is added select the Apply button and the pivot and chart will be populated. The grid and chart views can be toggled between the grid and chart icons. To view the chart results, select the chart icon and choose which chart type from the drop-down options. More details on using the charts will be covered in 'Customizing the Chart, Field Format and Layout' section.
.png)
.png)
.png)
NOTE: Selecting too many fields on which to pivot the data can impact performance. It is recommended that you select only one or two fields to pivot on.
NOTE: You can double click on a data set in a chart to see the details.
.png)
NOTE: The Fields dialog is presented by default but can be shown again after a pivot operation by clicking the Fields button in the toolbar.
.png)
Once fields are selected and the pivot is created, the selection can be revised at any time by returning to the Fields icon from either the grid or chart view of the pivot report.
.png)
NOTE: You can experiment with moving the Attributes to the Rows or Columns section in the pivoting area as well to see how the data grid is pivoted.
NOTE: You can also move multiple Attributes to the Rows or Columns sections to further pivot the data. This can, however, degrade performance so it is best to choose only one or two attributes to pivot on.
NOTE: If you have created a pivot using multiple fields you can use the Expand all data and the Collapse all data to quickly show or hide the subcategories of pivoted data. For example, if you pivot Crash Count by Age of Driver – Youngest Known and Crash Severity the grid will have categories of Age of Drive – Youngest known and sub-categories of Crash Severity.
.png)
Within the grid you can expand the subcategories by clicking on the small triangle next to the main category or you can expand all the subcategories by clicking on the Expand all data button. The same functionality can be used when viewing the pivot in charts.
.png)
.png)
You can filter the data selected for pivoting. To filter your data, click on the field name anywhere it appears in the pivot grid or chart area and the filter dialog box will open to give access to select desired filters. Once the filters are applied, the grid and chart will update to display the new filter criteria.
.png)
.png)
Within this dialog you can filter on the labels (the values being used to summarize data) or by values (the aggregate values of the chosen report measures). It is recommended to use labels to build your report. If you are looking for a range within labels, simply click the Select All check box resulting in all being deselected, scroll to the first desired set in the range, click the check box for this, scroll to the bottom of the desired range and make sure to hold both the Ctrl + Shift buttons on the keyboard while selecting the check box. This will make a group selection with 2 clicks. When satisfied simply click Apply.
.png)
To filter the labels using a method other than the check boxes click the LABELS button. With the resulting dialog create the desired filter. When filtering by labels, not all filter operators shown in the drop down will yield results. It is important to note labels are treated as strings and it is recommended to filter by check boxes rather than Label conditions.
.png)
To filter the values, click the VLAUES button. Within the resulting dialog create the desired filter. When satisfied click the APPLY button.
.png)
NOTE: Helpful Tip: Enter a title to describe your report into the Custom Title Box. This title can capture the criteria used to create the report and will be included in your exported reports.
NOTE: If a filter is applied the field name will indicate this with a filter icon next to where the label appears in the grid or chart.
.png)
Customizing the Chart, Field Format, and Layout
The chart image can be customized in a limited way. You can choose the chart type as well as apply a custom title. To choose the chart type select it from the Charts pick list.
.png)
Once selected the chart will render accordingly. If you have multiple aggregated values you will be able to configure how the charting of them in the chart dialog.
.png)
NOTE: Pivoting and charting data is a complex operation and you can certainly select an "incorrect" chart type to represent your pivoted data. It will take a bit of time experimenting to understand how to accurately portray your pivoted data. It is recommended to try switching attributes between columns and rows and display the results accordingly to review which configuration best suits the chart display. If using more than one attribute per column and row, stacked chart format is recommended for best readability.
NOTE: The chart image is restricted by your screen size. It can only render so many data points into the final image while maintaining readability. To fit the resultant image into the available space the chart labels may be sub-sampled. However, the chart data points should all still be rendered.
NOTE: To facilitate viewing a chart with many datasets or points you can choose to view it, or the gird, in full screen by clicking on the Fullscreen tool in the toolbar.
.png)
NOTE: You can hover over any chart data point to view its corresponding value. You can also double click on a data set in a chart to see the details.
.png)
Field formats can be customized as well. To do so click the Format tool in the toolbar.
.png)
You can format cells a number of ways by selecting the Format Cells option.
.png)
You can also apply conditional formatting by selecting the Conditional formatting option.
.png)
Layout options can also be configured to your preference. To do so select the Options tool in the toolbar.
.png)
Within the Layout options dialog you can experiment with updating the overall layout.
.png)
Having pivoted your data and adjusted your chart you may want to export or print the results. You can download both the pivoted grid data as well as a *.png image of the chart or you can print directly from within the tool. To export your grid or chart data select the desired option from the Export tool in the toolbar.
.png)
The exported chart or grid (if Image is chosen) will capture the user defined title as entered in the Custom Report Title.
.png)
Saving the Data and Chart Configuration
Having pivoted your data, you can save the configuration (fields, filters, order, sorting, formats, etc.) into a special file type called a JSON file. To save the configuration click on the Save tool in the toolbar.
.png)
After confirming, you will be prompted by your browser to save the "report.json" file and can rename the file to a more descriptive name for reference when re-using or sharing the report with others. Once saved it can be re-loaded into the pivoting application using the Open tool in the toolbar. the *.json files can be shared via email or stored on a server.
.png)
NOTE: The Crash Tabulation and Charting functionality in IMPACT is built on top of a very robust pivoting framework. This help system provides a high-level overview designed to produce a baseline pivot. For more extensive details on the capabilities of the pivoting framework please refer to the User Interface documentation here:
https://www.flexmonster.com/user-interface/
Not all the functionality available in the framework is provided in the Crash Tabulation and Charting interface. The version of Flexmonster employed in this application may not reflect the same version the Flexmonster support documentation is based upon.
Crash Tabulation and Charting >