community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Creating a chart to show start and end times

Atom

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!

Atom

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

Atom

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

 

Target Graph.PNG

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!

 

Sam

Labels