Average number of maintenance tasks per vehicle
SQL query for GeoDynamics
Calculate the average number of maintenance tasks per vehicle in the vehicle_maintenance_tasks table.
SELECT vehicle_id, AVG(task_count) FROM (SELECT vehicle_id, COUNT(*) AS task_count FROM vehicle_maintenance_tasks GROUP BY vehicle_id) AS subquery GROUP BY vehicle_id
GeoDynamics data model
Resource Types
View 2 columns
NameString
Resource_TypeNumber
Resourcegroups
Resources
Vehicles
Timeclocks
Point Of Interests
Poigroup
Poitype
Rfidtags
Mobile Rfid Scanners
Smartphones
Users
Overtimeconfigs
Clockings
Costcenters
Costcenter Validators
Day Programs
Assets
Asset Locations
Asset Inspection Types
Asset Identifications
Absencetypes
Access Schedules
Access Schedules Exceptions
Accessgroups
Access Locations
Maintenance
Vehicle Maintenance Tasks
Maintenance Types
Badges
Btw Numbers
Persons
Persons Limosa
Workplaces
Project Leads
Registrations
Mobileclocking Optionlist
Mobileclocking Multijoblist
Fleet Fuelsensors
Post Calculation Events
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed