Average number of clockings per person
SQL query for GeoDynamics
Calculate the average number of clockings per person in the clockings table.
SELECT person_id, AVG(clocking_count) FROM (SELECT person_id, COUNT(*) AS clocking_count FROM clockings GROUP BY person_id) AS subquery GROUP BY person_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