Burglary by Beat

Wave 2

4 reports · 510 runs (12 mo) · Medium · Target: Paginated report

Member reports Template Power BI output Validation (4)

Name	Source	Folder	Runs	Last run	Mapping
Burglary by Beat	TbTableau	Burglary by Beat - Agency G (2025)	468	9/30/2026 11:49 PM	Mapped
Burglary by Beat	TbTableau	Burglary by Beat - Agency K (2026 YTD)	22	9/6/2026 4:06 PM	Mapped
Burglary by Beat	TbTableau	Burglary by Beat - Agency H (2024)	14	9/4/2026 5:22 AM	Mapped
Burglary by Beat	TbTableau	Burglary by Beat - Agency C (2025)	6	9/1/2026 8:46 AM	Mapped

4 of 4

Template

Target: Paginated report
Parameters: @Agency, @DateFrom, @DateTo
Security: Row-level, by agency
Replaces: 4 reports
Layout: Standard

SELECT i.beat,
       CONVERT(char(7),
       i.occurred_date, 126) AS month,
       COUNT(*) AS incidents
FROM incident i
WHERE i.offense_code = '220'
  AND i.agency_id = @Agency
  AND i.occurred_date BETWEEN @DateFrom AND @DateTo
GROUP BY i.beat, CONVERT(char(7), i.occurred_date, 126)