Part A Offense Counts

<?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 o.offense_desc, o.crime_against, COUNT(*) AS offenses FROM incident i JOIN offense_code o ON o.offense_code = i.offense_code WHERE o.nibrs_group = 'A' AND i.agency_id = 10 AND i.occurred_date BETWEEN '2025-01-01' AND '2025-12-31' GROUP BY o.offense_desc, o.crime_against</relation>
</connection>
</datasource>
</datasources>
<worksheets>
<worksheet name='Part A Offense Counts'>
<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>