Burglary by Beat

Consolidate

Tableau Server and Cloud worksheet · /Agency H/Burglary by Beat - Agency H (2024)/Burglary by Beat

Agency_H/Incidents/Burglary_by_Beat_-_Agency_H_(2024).twb

<?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.beat, substr(i.occurred_date,1,7) AS month, COUNT(*) AS incidents FROM incident i WHERE i.offense_code = '220' AND i.agency_id = 8 AND i.occurred_date BETWEEN '2024-01-01' AND '2024-12-31' GROUP BY i.beat, substr(i.occurred_date,1,7)</relation>
</connection>
</datasource>
</datasources>
<worksheets>
<worksheet name='Burglary by Beat'>
<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>