Monthly Crime Trend

CJIWave 1

28 reports · 3,215 runs (12 mo) · Medium · Target: Power BI report

Member reports Template Power BI output Validation (20)

Dataset query (SQL Server)

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)