Gantt / time display of utilization/overlap

[AlexXandyr]

Hello everyone,

Im looking into the utilization of our boats, and would like to do that in a Gantt chart / time display. So that I can see potential overlaps and potential gaps between the 6 boats. I have the following data:
- Boat (1-6)
-Departure date including time

-Arrival date including time

-Operational time (arrival-departure)

Any way to show the below data in a visual way too find any overlaps/gaps in the utilization of boats? 

[v-jiewu-msft · Accepted solution]

Hi @AlexXandyr ,

Based on my testing, please try the following methods as workaround:

1.Create the simple table.

2.Select get more visuals and search the gantt visual.

3.Drag the Boat field into the Task and drag the Departure date into the start date.

4.Change the Visual general into the Hours duration unit.

5.The result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexXandyr]

Thank you @v-jiewu-msft. I did some modifications to the Gantt chart and grouped the boats to get a better overview