Validation › Location Type Analysis

Compare results

Match

Object: Location Type Analysis · Source: Tableau Server and Cloud · Target: Power BI report · Parameters: Agency G, 1/1/2025 to 12/31/2025

Download evidence Audit trail Open familyRefresh

Checks

Check	Source (Tableau)	Target (Power BI)	Result
Row count	7	7	Match
Total of incidents	1,453	1,453	Match
Record hash	8d9951384c7e	8d9951384c7e	Match

Access and audit

Data location: Agency network SC-28
Run by: Validation service, read only AC-6
This view: Logged AU-2
Evidence: Retained with the release AU-11

CJIS Security Policy controls

Source query

SELECT i.location_type,
       COUNT(*) AS incidents
FROM incident i
WHERE i.agency_id = 7
  AND i.occurred_date BETWEEN '2025-01-01' AND '2025-12-31'
GROUP BY i.location_type

Power BI dataset query

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