Number of time off requests by type
SQL query for BambooHR
This query will return the number of time off requests for each time off type.
SELECT timeoff_type, COUNT(*) FROM timeoff_requests JOIN timeoff_types ON timeoff_requests.timeoff_type_id = timeoff_types.timeoff_type_id GROUP BY timeoff_type
BambooHR data model
Employees Directory
Employee Dependents
Employee Last Change
Company Categories
Timeoff Types
Timeoff Policies
Timeoff Requests
Job Summaries
Hiring Leads
Application Statuses
Applications
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