1 of 1 people found this helpful
It's not your brain, it's your data. It needs to be reshaped from one row per file to one row per event, ideally with event durations rather than event times. I've attached the spreadsheet of reformatted data and a packaged workbook. Sheet 1 is stacked bars, Sheet 2 is stacked bars plus colored lines so you can more accurately see the trends for each event type. The reshaping should probably happen outside Tableau and if you can't get durations pre-calculated you'll have to use some tricky table calculations as described in this thread. We happen to be doing a lot of this ourselves as you might imagine.
Hi Zach, thought you might recognise the data sets
Well at least I know that its not my brain thats at fault here. I am building the warehouse so i have got full control over the data so i can re-shape it to fit. I read that other thread before and got a headache so re-shaping looks like its the way to go.
Thanks for putting me on the right path.