Report inventory › Vehicle Crime Summary - Agency H (Last 90 Days)
WI
Vehicle Crime Summary - Agency H (Last 90 Days)
ConsolidateAgency_H/Incidents/Vehicle_Crime_Summary_-_Agency_H_(Last_90_Days).json
{
"document": {
"id": 45789,
"cuid": "A82fe1df91ee363110bdab9",
"name": "Vehicle Crime Summary - Agency H (Last 90 Days)",
"folder": "Public Folders/Agency H/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 = 8 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": []
}