So this is much easier in Tableau...
If you look at the attached. I dragged ED Arrival (hr) (as Blue Pill) onto Rows, ED Arrival (min) onto Columns (as Green Dimension), changed the mark type to Gantt, and brought Median Boarding Time (mins) onto the size tile...and that's it
We can even colour it on the Median Boarding Time (mins) (or any other thing you want) with a further drag and drop!
Hope that is what you were after.
Gantt chart in Tableau.twbx 15.0 KB
Hi Simon, yes this is what I was looking for! Thank you very much!
I can't believe how much easier it is in Tableau!
I do have one follow up question. If I wanted this format, but a few different measures stacked, so not only a box for the Median Boarding Times, but also including Overlap into next day, is it possible to do that?
Very much so...I think that took me all of 8 seconds!
So yes you can do this, but the exactly set up will depend how you want them to be stacked.
In the attached I've used measure names/measure values (pseudo dimension and measure Tableau creates to let us plot, and colour, multiple measures). The way the gantt mark works, is that the gantt line is based on the position of that value, and then size will "streatch" the gantt mark that many unit in the chart. So in the current set up all 3 measures start from the 'ED Arrival (min)' and so only a few marks are visible (as they are as long, or not as line as the Median Boarding Time (mins) so are hidden behind it
If I bring measure names onto the rows shelf you can see this better
If you did want to stack them, we could do this, but would require a couple of extra calculations.
Gantt chart in Tableau.twbx 16.3 KB
The first chart you shared is what I was thinking of. I have some waiting times that go past midnight, thus falling into the "next day", and wanted to show those in a different color as a second box.
I've made a personal reference note to remember the position vs size/stretch for gantt marks and lines.
Thank you very much again Simon! This was super helpful!