Convert › F002
Location Type Analysis
Wave 3| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Location Type Analysis | TbTableau | Location Type Analysis - Agency F (2026 YTD) | 288 | 9/30/2026 7:52 AM | Mapped |
| Location Type Analysis | TbTableau | Location Type Analysis - Agency G (2025) | 6 | 9/5/2026 7:11 AM | Mapped |
| Location Type Analysis | TbTableau | Location Type Analysis - Agency L (2025) | 0 | Never | Mapped |
3 of 3
Template
- Target
- Power BI report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 3 reports
- Layout
- Standard
SELECT i.location_type, COUNT(*) AS incidents FROM incident i WHERE i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo GROUP BY i.location_type