Skip to main content

Peliqan

Try for free
Request a demo

Planday

Average shift duration by shift type

SQL query for Planday

Calculate the average duration of shifts for each shift type.

SELECT shifttype, AVG(duration) AS average_duration FROM Shifts GROUP BY shifttype

Try this query now in Planday

Planday data model

Planday
Shifts

View 14 columns
IdInteger
DateDate-time
StatusString
CommentString
EmployeeIdInteger
PositionIdInteger
EndDateTimeDate-time
ShiftTypeIdInteger
DepartmentIdInteger
StartDateTimeDate-time
DateTimeCreatedDate-time
EmployeeGroupIdInteger
DateTimeModifiedDate-time
PunchClockShiftIdInteger
Planday
Shifttypes

View 3 columns
IdInteger
NameString
IsActiveBoolean
Planday
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.

  • 14-day free trial
  • No credit card needed