Could you please attach your ample data, packaged workbook (**.twbx) is always the best.
Here are two examples, but neither of charts exactly satisfy your request.
The problem here is that
To keep seamless line chart, all the plot need to have value on discrete or axis need to be continuous.
Sheet1 : Both am/pm has plot and not single plot/day.
Sheet2: X-Axis shows all the dates including weekends
Anyways, you need to start duplicate datasource.
Table 1 as AM and Table 2 as PM.
sample_ampm_SM_10.1.twbx 246.6 KB
I appreciate the help. It makes sense why Tableau doesn't have this functionality to create hierarchies on axis by category, but this workaround will give me something along the lines of what I want.
I think duplicating the data source is the way to go.
1 of 1 people found this helpful
To clarify the essence..
The key is to have AM/PM as dimensions.
To achieve it, I used Union to duplicate data, but if data itself has AM/PM info as dimension, not need to duplicate data.