Convert › F003
Part A Offense Counts
Wave 3| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Part A Offense Counts | TbTableau | Part A Offense Counts - Agency H (2024) | 53 | 9/21/2026 6:12 AM | Mapped |
| Part A Offense Counts | TbTableau | Part A Offense Counts - Agency J (2025) | 39 | 9/29/2026 3:10 PM | Mapped |
| Part A Offense Counts | TbTableau | Part A Offense Counts - Agency E (2024) | 19 | 9/24/2026 5:19 AM | Mapped |
3 of 3
Template
- Target
- Paginated report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 3 reports
- Layout
- Standard
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 = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo GROUP BY o.offense_desc, o.crime_against