Before/After reports allow users to easily generate custom reports that compare trends in key data points across two selected date ranges.

This report compares the baseline date range against the comparison date range. It tracks the overall trend in key metrics from the Metrics Tab of the query, including the percentage change in serious and fatal crashes, as well as crash costs.

Additionally, the Before/After Report displays changes in crash counts and costs (annualized), the top differentiators between the two selected date ranges, and a summary of all Metrics from the Metrics Tab of the query.
​

To generate a Before/After Report in Crash Query, complete the steps outlined below:
​

1. Open Crash Query, and enter the desired filter criteria for your Before/After Report.
​

2. From the Metrics Tab, select the metrics you would like to include in the report by clicking on the Manage Metrics icon, and selecting the metrics to include.
​

3. Click on the download icon (an arrow facing down) in the top right corner of the screen (located to the far left of the Save button), and select Before/After Report.

4. In the Report Options window, enter the report title and the requester of the report (optional) in the corresponding fields, then select the date ranges for the comparison. Click in the Date Range 1 field, and select the start and end date for the baseline portion of the report (generally the older of the two date ranges).
When the baseline date range is selected, select the comparison date range by clicking the Date Range 2 field, then enter the start and end dates for the comparison portion of the report (generally the more recent of the two date ranges).

5. When the report options window is filled out, click the Create Report button. A new tab will open, and Crash Query will generate a preview of the report.
​

6. Review the report to ensure it contains the desired data. If the report is correct, click the Save and Download button in the top-right corner (clicking the Back button in the top-left corner will return you to Crash Query without saving the report).
​

7. Crash Query will then generate the report, download a PDF to your local computer, and save the report in the Reports section of Numetric.