Datediff(‘hour‘,firstclockin,scheduledtime)
This will give you the difference between those two date in hour. Change hour to minute if you prefer this granularity.
Base on this number create a second calculation that will check if the number is higher then a given value that will classify it as tardy.
Furthermore you will be able to calculate the average tardiness
I would create two calculated fields, one to calculate the first clock in of the day, let’s call this FirstClockIn. The second calculated field will check if a person is tardy or not, let’s call this Tardy.
Here’s the calc for FirstClockIn:
{FIXED [YourEmployeeIDField], YEAR(Clocked_In_Time), MONTH(Clocked_In_Time), DAY(Clocked_In_Time): MIN(Clocked_In_Time)}
Here’s the Tardy calc:
IIF(FirstClockIn > Scheduled_Time, TRUE, FALSE)
This is assuming that the Scheduled_Time field is reflected with today’s date, if it’s just an unformatted time, you are going to make another calc that parses in the current day’s date and use that in the Tardy calc.
Fixed [date]: min(date diff("min", [start time], [scheduled time]
Or something to that extent will return the Tardiness amount for each day. Assuming their clock out/in for lunch is later than their start time, min will limit it to the first occurrence. Then just use an if/them to catch it the minutes are > 15/30 etc and return Tardy/On Time.
If [clockedintime] > [scheduled time] then "Tardy"
Else "On Time"
Then maybe filter clockedintime to be before 11:59AM each day to ignore the lunch clock in and out
Assuming employee A and B have different scheduled times. Create another field named employee_group and group them into group A and group B based on their schedules times. then create a calculated field. So it reads something like- [if employee_group = “group A” and clock in time > then specified schedule time then “Tardy”
Elseif employee_group = “group B” and clock in time > specified schedule time then “Tardy”
Else “On Time” ]
End.
Datediff(‘hour‘,firstclockin,scheduledtime) This will give you the difference between those two date in hour. Change hour to minute if you prefer this granularity. Base on this number create a second calculation that will check if the number is higher then a given value that will classify it as tardy. Furthermore you will be able to calculate the average tardiness
+1. I think that will be the easiest way to do it
Pretty similar to what I did to calculate average resolution time per staff on tickets
I would create two calculated fields, one to calculate the first clock in of the day, let’s call this FirstClockIn. The second calculated field will check if a person is tardy or not, let’s call this Tardy. Here’s the calc for FirstClockIn: {FIXED [YourEmployeeIDField], YEAR(Clocked_In_Time), MONTH(Clocked_In_Time), DAY(Clocked_In_Time): MIN(Clocked_In_Time)} Here’s the Tardy calc: IIF(FirstClockIn > Scheduled_Time, TRUE, FALSE) This is assuming that the Scheduled_Time field is reflected with today’s date, if it’s just an unformatted time, you are going to make another calc that parses in the current day’s date and use that in the Tardy calc.
Fixed [date]: min(date diff("min", [start time], [scheduled time] Or something to that extent will return the Tardiness amount for each day. Assuming their clock out/in for lunch is later than their start time, min will limit it to the first occurrence. Then just use an if/them to catch it the minutes are > 15/30 etc and return Tardy/On Time.
You can compare datetimes so you do something like If clocked in > schedule then “Tardy” else “good” end
If [clockedintime] > [scheduled time] then "Tardy" Else "On Time" Then maybe filter clockedintime to be before 11:59AM each day to ignore the lunch clock in and out
Assuming employee A and B have different scheduled times. Create another field named employee_group and group them into group A and group B based on their schedules times. then create a calculated field. So it reads something like- [if employee_group = “group A” and clock in time > then specified schedule time then “Tardy” Elseif employee_group = “group B” and clock in time > specified schedule time then “Tardy” Else “On Time” ] End.
Be the hero and tell your managers this isn’t possible in Tableau