Creating a chart to show start and end times

[Build_It]

I have a set of data with the following fields:

Division

Region

Branch

Vehicle

Average start time

Average end time

There are three divisions, each division has several regions which each have several branches, and each branch has several vehicles.  Each vehicle has a unique registration number.

I'd like to create a series of charts which gives, split by branch, a graphical representation of the average start and end times that each vehicle is used. 

I'd like the information to be presented horizontally so that the time is along the x-axis and the vehicles are plotted as horizontal bars beginning at the start time and ending at the end time.

The idea is that the branches will be able to see at a glance how the vehicles are being utilised.

Is this possible within Alteryx?

I don't know where to begin!

[Build_It]

This is the kind of thing I'm aiming for (created in Excel):

[Build_It]

This is the kind of thing I'm aiming for; I have mocked it up in Excel:

[SamDesk]

Hey @Build_It,

To achieve the output you're looking for I had to create the graph in Tableau. I did try to get it working solely in Alteryx but was unable to.

So this workflow works by calculating the time difference from a fixed DateTime (1900-01-01 00:00:00) for given start and end times, from that it calculates the average difference. Adding this back to the fixed DateTime we can get the average start and end times. Note I am rounding these average times to the nearest minute here.

Next, to be able to display the bar charts alongside one another we need to simulate data for all the time in-between these start and end times. This is achieved using the Generate Rows tool.

Finally, we can export this as a file that Tableau can use. Here I've used a .hyper but you could use any supported file type. And then produce the graph below.

Hope this helps!

Sam