This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.