Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Convert › F002

Monthly Crime Trend

CJIWave 1
28 reports  ·  3,215 runs (12 mo)  ·  Medium  ·  Target: Power BI report
Download TMDLView outputRefresh
Member reportsTemplatePower BI outputValidation (20)
NameSourceFolderRunsLast runMapping
Monthly Crime Trend - Agency K (2026 YTD)CoCognos Executive1,1899/30/2026 10:36 PMMapped
Monthly Crime Trend - Agency F (Last 90 Days)CoCognos Executive1,0609/30/2026 5:09 PMMapped
Monthly Crime Trend - Agency C (2026 YTD)CoCognos Executive4139/30/2026 9:27 PMMapped
Monthly Crime Trend - Agency D (2024)CoCognos Executive3479/27/2026 5:07 PMMapped
Monthly Crime Trend - Agency E (2025)CoCognos Executive359/11/2026 3:04 PMMapped
Monthly Crime Trend - Agency H (Last 90 Days)CoCognos Executive208/14/2026 3:23 AMMapped
Monthly Crime Trend - Agency C (2024)CoCognos Executive209/24/2026 9:41 AMMapped
Copy of Monthly Crime TrendCoCognos user519189/17/2026 4:08 AMMapped
Copy of Monthly Crime TrendCoCognos user172168/25/2026 4:32 AMMapped
Monthly Crime Trend - Agency C (2025)CoCognos Executive159/24/2026 5:22 AMMapped
Monthly Crime Trend - Agency F (2025)CoCognos Executive108/9/2026 7:41 PMMapped
Monthly Crime Trend - Agency H (2025)CoCognos Executive109/24/2026 5:17 AMMapped
Monthly Crime Trend - Agency G (Last 90 Days)CoCognos Executive99/15/2026 3:32 PMMapped
Copy of Monthly Crime TrendCoCognos user47798/27/2026 7:53 AMMapped
Monthly Crime Trend - Agency I (2025)CoCognos Executive99/20/2026 5:11 AMMapped
Monthly Crime Trend - Agency L (2025)CoCognos Executive99/4/2026 12:16 AMMapped
Copy of Monthly Crime TrendCoCognos user18789/20/2026 6:15 PMMapped
Copy of Monthly Crime TrendCoCognos user20563/22/2026 6:33 AMMapped
Monthly Crime Trend - Agency F (2026 YTD)CoCognos Executive67/17/2026 7:35 AMMapped
Monthly Crime Trend - Agency I (Last 90 Days)CoCognos Executive67/3/2026 10:38 AMMapped
Monthly Crime Trend - Agency E (2024)CoCognos Executive0NeverMapped
Copy of Monthly Crime TrendCoCognos user4230NeverMapped
Monthly Crime Trend - Agency G (2026 YTD)CoCognos Executive0NeverMapped
Monthly Crime Trend - Agency I (2024)CoCognos Executive0NeverMapped
Monthly Crime Trend - Agency E (Last 90 Days)CoCognos Executive0NeverMapped
Monthly Crime Trend - Agency H (2024)CoCognos Executive0NeverMapped
Monthly Crime Trend - Agency A (2025)CoCognos Executive0NeverMapped
Monthly Crime Trend - Agency G (2025)CoCognos Executive0NeverMapped
28 of 28
Template
Target
Power BI report
Parameters
@Agency, @DateFrom, @DateTo
Security
Row-level, by agency
Replaces
28 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)