Convert › F006
Monthly Crime Trend
CJIWave 2| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Monthly Crime Trend - Agency C (2025) | RSSSRS | Executive | 736 | 9/29/2026 3:30 PM | Mapped |
| Monthly Crime Trend - Agency E (2024) | RSSSRS | Executive | 19 | 7/24/2026 2:08 AM | Mapped |
| Monthly Crime Trend - Agency D (Last 90 Days) | RSSSRS | Executive | 12 | 7/29/2026 5:35 PM | Mapped |
| Monthly Crime Trend - Agency H (Last 90 Days) | RSSSRS | Executive | 0 | Never | Mapped |
4 of 4
Template
- Target
- Power BI report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 4 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)