Convert › F007
Vehicle Crime Summary
Wave 2| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Vehicle Crime Summary - Agency B (Last 90 Days) | WIWeb Intelligence | Incidents | 429 | 9/27/2026 5:08 PM | Mapped |
| Vehicle Crime Summary - Agency J (2025) | WIWeb Intelligence | Incidents | 395 | 9/30/2026 8:07 PM | Mapped |
| Vehicle Crime Summary - Agency E (2024) | WIWeb Intelligence | Incidents | 35 | 9/17/2026 3:51 AM | Mapped |
| Vehicle Crime Summary - Agency L (2026 YTD) | WIWeb Intelligence | Incidents | 21 | 9/14/2026 6:32 PM | Mapped |
| Vehicle Crime Summary - Agency C (2026 YTD) | WIWeb Intelligence | Incidents | 20 | 9/18/2026 12:49 AM | Mapped |
| Vehicle Crime Summary - Agency H (Last 90 Days) | WIWeb Intelligence | Incidents | 8 | 8/29/2026 7:22 PM | Mapped |
| Vehicle Crime Summary - Agency D (2024) | WIWeb Intelligence | Incidents | 6 | 6/30/2026 10:03 PM | Mapped |
| Vehicle Crime Summary - Agency G (Last 90 Days) | WIWeb Intelligence | Incidents | 0 | Never | Mapped |
| Vehicle Crime Summary - Agency A (2024) | WIWeb Intelligence | Incidents | 0 | Never | Mapped |
9 of 9
Template
- Target
- Power BI report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 9 reports
- Layout
- Standard
SELECT i.offense_code, COUNT(*) AS incidents, SUM(i.property_loss) AS loss FROM incident i WHERE i.offense_code IN ('23F','240') AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo GROUP BY i.offense_code