Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Creating a chart to show start and end times

5 - Atom

I have a set of data with the following fields:






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!

5 - Atom

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

5 - Atom

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


Target Graph.PNG

11 - Bolide

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.


Annotation 2019-10-23 160246.png


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.

Dashboard 1.png


Hope this helps!