Monthly Crime Trend

<?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 substr(i.occurred_date,1,7) AS month, COUNT(*) AS incidents FROM incident i WHERE i.agency_id = 5 AND i.occurred_date BETWEEN '2026-01-01' AND '2026-09-30' GROUP BY substr(i.occurred_date,1,7)</relation>
</connection>
</datasource>
</datasources>
<worksheets>
<worksheet name='Monthly Crime Trend'>
<table>
<view>
<datasources>
<datasource name='federated.1'/>
</datasources>
</view>
<rows>[measure]</rows>
<cols/>
<panes>
<pane>
<mark class='Bar'/>
</pane>
</panes>
</table>
</worksheet>
</worksheets>
</workbook>