Can you please post a packaged workbook with a sample of your data? I'm not sure of the structure of your data, eg, whether you have lots of shifts starting each day (early and late shifts for example) and lots of staff.
However, I have made up a bit of data and come up with this:
My method for extracting the time is a bit long winded! There's probably a better way.
Date Time chart (15606).twbx 16.8 KB
Hi juliette.mccormack - I got there too with some googling and found this:
I think being a Tableau newbie I finding the differences between dimensions, continuous variables etc hard to get my head around. Now I have a chart that looks identical to yours (but with different data).
So in your example, how can I plot that as a continuous line chart?
It's already a continuous measure in my workbook. The green pill identifies it as continuous rather than discrete and a green pill creates an axis (the bottom of the menu shown in the image shows it as Continuous).
So, you should be able to just change the type on the Marks card to line:
If that doesn't work, if you'd like to attach a workbook with your sample data, I'd be happy to look at it.