Report inventory › Vehicle Crime Summary - Agency G (Last 90 Days)
WI
Vehicle Crime Summary - Agency G (Last 90 Days)
RetireAgency_G/Incidents/Vehicle_Crime_Summary_-_Agency_G_(Last_90_Days).json
{
"document": {
"id": 97521,
"cuid": "Ad59954ae20ae3b76826726",
"name": "Vehicle Crime Summary - Agency G (Last 90 Days)",
"folder": "Public Folders/Agency G/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 = 7 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": []
}