Vehicle Crime Summary

<?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 i.offense_code, COUNT(*) AS incidents, SUM(i.property_loss) AS loss FROM incident i WHERE i.offense_code IN ('23F','240') AND i.agency_id = 12 AND i.occurred_date BETWEEN '2026-07-02' AND '2026-09-30' GROUP BY i.offense_code</relation>
</connection>
</datasource>
</datasources>
<worksheets>
<worksheet name='Vehicle Crime Summary'>
<table>
<view>
<datasources>
<datasource name='federated.1'/>
</datasources>
</view>
<rows>[measure]</rows>
<cols/>
<panes>
<pane>
<mark class='Bar'/>
</pane>
</panes>
</table>
</worksheet>
</worksheets>
</workbook>