Resource Utilization
SQL query for Ganttic
Calculate the utilization of each resource.
SELECT resource_id, SUM(duration) / COUNT(DISTINCT date) AS utilization FROM tasks GROUP BY resource_id
Ganttic data model
Users
Projects
Resources
Tasks
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