Report inventory › Vehicle Crime Summary - Agency B (Last 90 Days)
WI
Vehicle Crime Summary - Agency B (Last 90 Days)
MigrateAgency_B/Incidents/Vehicle_Crime_Summary_-_Agency_B_(Last_90_Days).json
{
"document": {
"id": 77715,
"cuid": "A540b5f746448f49aede43c",
"name": "Vehicle Crime Summary - Agency B (Last 90 Days)",
"folder": "Public Folders/Agency B/Incidents",
"owner": "Administrator"
},
"dataProviders": [
{
"id": "DP0",
"name": "Query 1",
"dataSourceType": "unx",
"dataSourceName": "Justice Reporting.unx",
"queryplan": "<queryplan custom=\"false\" editable=\"true\"><statement index=\"1\">SELECT i.offense_code, COUNT(*) AS incidents, SUM(i.property_loss) AS loss FROM incident i WHERE i.offense_code IN ('23F','240') AND i.agency_id = 2 AND i.occurred_date BETWEEN '2026-07-02' AND '2026-09-30' GROUP BY i.offense_code</statement></queryplan>"
}
],
"reports": [
{
"id": 1,
"name": "Report 1",
"elements": [
{
"type": "VBarChart",
"dataProvider": "DP0"
}
]
}
],
"alerters": [],
"variables": [],
"parameters": []
}