Citations by Violation

<?xml version='1.0' encoding='utf-8' ?>
<workbook source-build='2024.2.3' version='18.1'>
<datasources>
<datasource caption='RJDW' name='federated.1'>
<connection class='federated'>
<named-connections>
<named-connection caption='rjdw-sql' name='sqlserver.1'>
<connection class='sqlserver' dbname='RJDW' server='rjdw-sql'/>
</named-connection>
</named-connections>
<relation connection='sqlserver.1' name='Custom SQL Query' type='text'>SELECT c.violation, substr(c.issued_date,1,7) AS month, COUNT(*) AS citations, SUM(c.fine) AS fines FROM citation c WHERE c.agency_id = 12 AND c.issued_date BETWEEN '2025-01-01' AND '2025-12-31' GROUP BY c.violation, substr(c.issued_date,1,7)</relation>
</connection>
</datasource>
</datasources>
<worksheets>
<worksheet name='Citations by Violation'>
<table>
<view>
<datasources>
<datasource name='federated.1'/>
</datasources>
</view>
<rows>[measure]</rows>
<cols>[month]</cols>
<panes>
<pane>
<mark class='Text'/>
</pane>
</panes>
</table>
</worksheet>
</worksheets>
</workbook>