Validation › Monthly Crime Trend - Agency L (Last 90 Days)

Compare results

Match

Object: Monthly Crime Trend - Agency L (Last 90 Days) · Source: SAP BusinessObjects Web Intelligence · Target: Power BI report · Parameters: Agency L, 7/2/2026 to 9/30/2026

Download evidence Audit trail Open familyRefresh

Checks

Check	Source (Web Intelligence)	Target (Power BI)	Result
Row count	3	3	Match
Total of incidents	381	381	Match
Record hash	646fffcb3c64	646fffcb3c64	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 substr(i.occurred_date,1,7) AS month,
       COUNT(*) AS incidents
FROM incident i
WHERE i.agency_id = 12
  AND i.occurred_date BETWEEN '2026-07-02' AND '2026-09-30'
GROUP BY substr(i.occurred_date,1,7)

Power BI dataset query

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