Hi all,
Please could you perhaps point me in a direction to create a report similar to a Gantt chart
I am not sure how to approach this
I have a list of personnel
They need to go on a trip for period x, return, and go on leave for a period
Not all the personnel have the same rotation and different leave days
Some personnel go to different locations in a rotation
I have a start date
number of days at each location
and number of days leave
I want a report to calculate the date return and back on rotation again
Below is a sample
Once this calculation has been done, a 12 month forecast must be visible
Please could you perhaps point me in a direction to create a report similar to a Gantt chart
I am not sure how to approach this
I have a list of personnel
They need to go on a trip for period x, return, and go on leave for a period
Not all the personnel have the same rotation and different leave days
Some personnel go to different locations in a rotation
I have a start date
number of days at each location
and number of days leave
I want a report to calculate the date return and back on rotation again
Below is a sample
| Employee | Date Start | Location 1 | Location 1 Days | Location 2 | Location 2 Days | Leave days | ||
| Me | 1/1/2024 | UK | 8 | Africa | 6 | 4 | ||
| You | 1/1/2024 | UK | 16 | 4 | ||||
Expected Report | ||||||||
| Employee | Location 1 | Date Start | End Date | Location 2 | Date Start | End Date | Leave Start | Leave End |
| Me | UK | 1/1/2024 | 9/1/2024 | 10/1/2024 | 10/1/2024 | 16/01/2024 | 17/01/2024 | 21/01/2024 |
| You | UK | 1/1/2024 | 17/01/2024 | 18/01/2024 | 21/01/2024 |
Once this calculation has been done, a 12 month forecast must be visible
