Migration Workbench | Workspace: CJIS environment Sample data
MFA RE
Convert › F003

Location Type Analysis

CJIWave 1
24 reports  ·  3,172 runs (12 mo)  ·  Medium  ·  Target: Power BI report
Download TMDLView outputRefresh
Member reportsTemplatePower BI outputValidation (14)
NameSourceFolderRunsLast runMapping
Location Type Analysis - Agency H (2026 YTD)CoCognos Incidents1,3279/30/2026 11:12 PMMapped
Location Type Analysis - Agency G (Last 90 Days)CoCognos Incidents6069/30/2026 9:09 PMMapped
Copy of Location Type AnalysisCoCognos user1665559/30/2026 11:24 PMMapped
Location Type Analysis - Agency H (Last 90 Days)CoCognos Incidents3019/30/2026 4:23 AMMapped
Location Type Analysis - Agency L (Last 90 Days)CoCognos Incidents2639/28/2026 9:48 AMMapped
Location Type Analysis - Agency A (Last 90 Days)CoCognos Incidents279/26/2026 8:18 PMMapped
Location Type Analysis - Agency B (Last 90 Days)CoCognos Incidents218/28/2026 8:00 PMMapped
Copy of Location Type AnalysisCoCognos user288198/21/2026 12:18 PMMapped
Copy of Location Type AnalysisCoCognos user514149/19/2026 5:51 AMMapped
Location Type Analysis - Agency J (Last 90 Days)CoCognos Incidents119/22/2026 3:37 PMMapped
Location Type Analysis - Agency F (2025)CoCognos Incidents99/21/2026 8:52 PMMapped
Copy of Location Type AnalysisCoCognos user35879/13/2026 10:48 AMMapped
Location Type Analysis - Agency B (2024)CoCognos Incidents68/17/2026 11:35 PMMapped
Copy of Location Type AnalysisCoCognos user14668/28/2026 2:18 AMMapped
Location Type Analysis - Agency D (2026 YTD)CoCognos Incidents0NeverMapped
Location Type Analysis - Agency F (2026 YTD)CoCognos Incidents0NeverMapped
Location Type Analysis - Agency K (2025)CoCognos Incidents0NeverMapped
Location Type Analysis - Agency D (2025)CoCognos Incidents0NeverMapped
Location Type Analysis - Agency H (2025)CoCognos Incidents0NeverMapped
Location Type Analysis - Agency A (2025)CoCognos Incidents0NeverMapped
Location Type Analysis - Agency J (2025)CoCognos Incidents0NeverMapped
Copy of Location Type AnalysisCoCognos user3500NeverMapped
Location Type Analysis - Agency F (Last 90 Days)CoCognos Incidents0NeverMapped
Location Type Analysis - Agency B (2026 YTD)CoCognos Incidents0NeverMapped
24 of 24
Template
Target
Power BI report
Parameters
@Agency, @DateFrom, @DateTo
Security
Row-level, by agency
Replaces
24 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