Convert › F002
Monthly Crime Trend
Wave 1| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Monthly Crime Trend - Agency E (2024) | WIWeb Intelligence | Executive | 1,043 | 9/30/2026 8:30 PM | Mapped |
| Monthly Crime Trend - Agency I (Last 90 Days) | WIWeb Intelligence | Executive | 876 | 9/30/2026 6:53 AM | Mapped |
| Monthly Crime Trend - Agency H (Last 90 Days) | WIWeb Intelligence | Executive | 709 | 9/30/2026 10:21 PM | Mapped |
| Monthly Crime Trend - Agency A (Last 90 Days) | WIWeb Intelligence | Executive | 119 | 9/28/2026 11:37 AM | Mapped |
| Monthly Crime Trend - Agency D (2025) | WIWeb Intelligence | Executive | 54 | 9/19/2026 6:05 PM | Mapped |
| Monthly Crime Trend - Agency L (Last 90 Days) | WIWeb Intelligence | Executive | 26 | 9/26/2026 8:49 PM | Mapped |
| Monthly Crime Trend - Agency G (2024) | WIWeb Intelligence | Executive | 11 | 9/27/2026 2:12 PM | Mapped |
| Monthly Crime Trend - Agency B (2024) | WIWeb Intelligence | Executive | 10 | 8/11/2026 8:55 AM | Mapped |
| Monthly Crime Trend - Agency C (2024) | WIWeb Intelligence | Executive | 10 | 9/23/2026 6:51 PM | Mapped |
9 of 9
Template
- Target
- Power BI report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 9 reports
- Layout
- Standard
SELECT CONVERT(char(7), i.occurred_date, 126) AS month, COUNT(*) AS incidents FROM incident i WHERE i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo GROUP BY CONVERT(char(7), i.occurred_date, 126)