Monthly Crime Trend

Wave 1

9 reports · 2,858 runs (12 mo) · Medium · Target: Power BI report

Member reports Template Power BI output Validation (9)

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)