Citations by Violation

CJIWave 3

7 reports · 22 runs (12 mo) · Medium · Target: Paginated report

Member reports Template Power BI output Validation (2)

Dataset query (SQL Server)

SELECT c.violation,
       CONVERT(char(7),
       c.issued_date, 126) AS month,
       COUNT(*) AS citations,
       SUM(c.fine) AS fines
FROM citation c
WHERE c.agency_id = @Agency
  AND c.issued_date BETWEEN @DateFrom AND @DateTo
GROUP BY c.violation, CONVERT(char(7), c.issued_date, 126)