Convert › F003
Clearance Rate by Offense
Wave 2| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Clearance Rate by Offense - Agency J (2026 YTD) | WIWeb Intelligence | NIBRS | 969 | 9/30/2026 11:02 AM | Mapped |
| Clearance Rate by Offense - Agency E (2024) | WIWeb Intelligence | NIBRS | 346 | 9/29/2026 9:28 AM | Mapped |
| Clearance Rate by Offense - Agency C (Last 90 Days) | WIWeb Intelligence | NIBRS | 13 | 8/31/2026 6:44 PM | Mapped |
| Clearance Rate by Offense - Agency H (2026 YTD) | WIWeb Intelligence | NIBRS | 8 | 9/22/2026 3:34 PM | Mapped |
| Clearance Rate by Offense - Agency B (2024) | WIWeb Intelligence | NIBRS | 7 | 5/22/2026 2:21 PM | Mapped |
| Clearance Rate by Offense - Agency L (Last 90 Days) | WIWeb Intelligence | NIBRS | 7 | 9/25/2026 2:50 PM | Mapped |
| Clearance Rate by Offense - Agency D (2026 YTD) | WIWeb Intelligence | NIBRS | 0 | Never | Mapped |
7 of 7
Template
- Target
- Paginated report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 7 reports
- Layout
- Standard
SELECT i.offense_code, COUNT(*) AS incidents, SUM(i.cleared) AS cleared FROM incident i WHERE i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo GROUP BY i.offense_code