The Before/After Report compares two date ranges for the same query, so you can see how crashes changed, for example, before and after a safety project. This article shows what's in the report and how to create one.
What's in the Report
Time Ranges: Each date range, its length in days, its total crashes, and the count and percent for each severity.
Change Overview (annualized): The change in serious crashes, fatal crashes, and crash cost between the two ranges.
Crash Counts & Cost (annualized): The crash count and cost for each severity in each range, and the difference.
Top Differentiators: The metric values that changed the most between the two ranges.
Metrics: Every metric in your Metrics tab, with the percent for each range and the difference.
(The Time Ranges, Change Overview, Crash Counts & Cost, and Top Differentiators sections)
Date Range 1 is the first, or baseline, range. Date Range 2 is the second range you compare it with.
Create a Before/After Report
Set up your query. Add the filters you want, and select the metrics in the Metrics tab.
Click the Download icon (down arrow) in the top-right corner, to the left of Save.
Click Before/After.
In Report Options, enter a Report Title (it starts as your query name) and, optionally, Requested By.
Click Date Range 1, select the start and end dates for the baseline, and then click Done. This is usually the older of the two ranges.
Click Date Range 2, select the start and end dates for the comparison, and then click Done. This is usually the more recent range. Match the length of Date Range 2 to Date Range 1 is selected by default.
(The Report Options window for a Before/After report)
7. Click Create Report. A preview of the report opens.
8. Review the report. To save it, click Save & Download in the top-right corner. To go back to Crash Query without saving, click Back in the top-left corner.
The PDF downloads to your computer, and the report is saved in Reports under Reports > Archives, where you can download it again.


