Citations by Violation

Wave 3

2 reports · 11 runs (12 mo) · Medium · Target: Paginated report

Member reports Template Power BI output Validation (1)

Name	Source	Folder	Runs	Last run	Mapping
Citations by Violation	TbTableau	Citations by Violation - Agency L (2025)	11	9/14/2026 5:26 PM	Mapped
Citations by Violation	TbTableau	Citations by Violation - Agency J (2025)	0	Never	Mapped

2 of 2

Template

Target: Paginated report
Parameters: @Agency, @DateFrom, @DateTo
Security: Row-level, by agency
Replaces: 2 reports
Layout: Standard

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)