Here’s an plan which I assigned 2 shifts for 2 employee. Example Date 23/10/2024: Employee 1 ‘ll work from 7am → 7pm & Employee 2’ ll work from 10 am → 10 pm
In real life, Employee 2 can swap shift with Employee 1, so Employee’ll change to work from 10am → 10pm and employee 1’ ll change 7am → 7pm
How should I using timeline or calendar to see this difference between plan vs actual ?
For more complex use case, On date 23/10/2024 Employee 1 have planned shift from 7am → 7pm, but in actual: Employee 2 take 7am → 10am, Employee 3 take from 10 am → 2pm, and then Employee 1 actual work from 2pm → 7pm …
I dont wanna break into 2 view: plan and actual shifts, I need it’s overlap to see overall. How should i use timeline view to have an overview for this ?
the problem’s not come from time fields only Chris
You can see in this example “On date 23/10/2024 Employee 1 have planned shift from 7am → 7pm, but in actual: Employee 2 take 7am → 10am, Employee 3 take from 10 am → 2pm, and then Employee 1 actual work from 2pm → 7pm …”
1 orginal date range can split into 3 parts ⇄ 3 date range with different people field assigned
How about this:
you use the primary date fields to show actual hours worked and the secondary date fields to show the planned ones.
For people who were not planned to work, but did, the secondary field can be empty.
In most cases, the date fields will be the same (perhaps you need an automation to copy the secondary field values to the primary by default).
You can modify peoples field values manually if needed, and you can create new extraordinary entities to cover the case where people take on an extra unplanned shift.
Wow, clever suggestion as always, Chris
You’re right, most cases actual = planned, but What condition should I use for this automation “you need an automation to copy the secondary field values to the primary by default”
In this thing, You mean from 1 orginal entity with daterange (planned shift) I can break into 3 entities with different date-range and employee right, so I need to self-auto relation in this database ?
other things, current Shift timing 's formula type, How should I convert to Date type to selectable for those new extraordinary entities ?
In this thing, You mean from 1 orginal entity with daterange (planned shift) I can break into 3 entities with different date-range and employee right, so I need to self-auto relation in this database ?
other things, current Shift timing 's formula type, How should I convert to Date type to selectable for those new extraordinary entities ?
If you create an ‘extraordinary’ Shift entity manually, there will be no Shift pattern, and the formula for calculating the planned Shift timing will be empty if there is no assigned Shift pattern.
(on the above image, there are no secondary dates for the time that Chris and Mary worked)
this thing 's really make me confused. If not a self-relations, it’s really hard to determine which actual belongs to main entity
Can any have solution with relation for this in an overlap way (1 row planed and 3 actual in 1 way)
Employee A - planned 05 → 17, actual 05 → 17
In your example image, it looks like Employee 8 had a planned shift (07-19) but ended up working for 3 hours of Employee 9’s shift.
Maybe Employee 8 should have two entities (like Employee 1 does)?
Anyway, that’s not the point.
It is not possible to have in one row all the various periods that were actually worked if you want lanes per employee - these three entities have to live in different lanes.
Also, the secondary date range will act as a blocker to prevent other entities occupying the same space.
TBH, the simplest thing to do may be to add a checkbox formula which is true if actual != planned and then colour code on the timeline for visibility. So at least you will see deviations clearly.
If you’re trying to find a smart way to automatically identify when a planned shift is not totally covered (like in your example) then yes, you would need to find a way of linking the extraordinary shifts to the planned one, and maybe do some clever formula to find out where any gaps are, but I don’t think it will be easy.
