Total shifts by shift type - Planday SQL Query - Peliqan

Total shifts by shift type

SQL query for Planday

Get the total number of shifts for each shift type.

SELECT shifttype, COUNT(*) AS total_shifts FROM Shifts GROUP BY shifttype

Planday data model

Shifts

View 14 columns

IdInteger

DateDate-time

StatusString

CommentString

EmployeeIdInteger

PositionIdInteger

EndDateTimeDate-time

ShiftTypeIdInteger

DepartmentIdInteger

StartDateTimeDate-time

DateTimeCreatedDate-time

EmployeeGroupIdInteger

DateTimeModifiedDate-time

PunchClockShiftIdInteger

Shifttypes

View 3 columns

IdInteger

NameString

IsActiveBoolean

Employees

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.