Forum Discussion
How to model Vehicle Availability data from planned date data
I have following format of data as show below. This has the Vehicle ID which are planned during those dates. I am looking to show "Vehicle Availability" for all dates (not just planned date range) and for all vehicles in a calendar view as well as a Count view.
I also have a Vehicle Master which will have ALL VEHICLES. SO the vehicle availabilty should show vehicles which are not planned at all as well as vehicles which are outside these planned dates
| Vehicle ID | Plan Start | Plan End |
| BCD-PUDMOTOR-001 | 19-01-2023 | 19-01-2023 |
| BCD-PUDMOTOR-001 | 25-01-2023 | 25-01-2023 |
| BCD-PUDMOTOR-001 | 02-02-2023 | 02-02-2023 |
| BCD-PUDMOTOR-001 | 03-02-2023 | 03-02-2023 |
| BCD-PUDMOTOR-001 | 06-02-2023 | 06-02-2023 |
| BCD-PUDMOTOR-001 | 09-02-2023 | 09-02-2023 |
| BCD-PUDMOTOR-001 | 12-02-2023 | 12-02-2023 |
| BCD-PUDMOTOR-001 | 16-02-2023 | 16-02-2023 |
| BCD-PUDMOTOR-001 | 17-02-2023 | 17-02-2023 |
| BCD-PUDMOTOR-001 | 18-02-2023 | 18-02-2023 |
| BCD-PUDMOTOR-001 | 19-02-2023 | 19-02-2023 |
1 Reply
- lbendlin
Super User
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
