Yes, it's quite troublesome to draw this excel-like charts.
Tableau is not designed at this point to create "Group Bar" or "Clustered Bar" charts.
- Crate continuous X-axis
- Differentiate Dimension by changing the Axis Value itself
will help to create this particular view. Though it's pretty complicated I agree.
Anyways, you need to start Pivoting data.
From edit Data Source.
dateparse("MMyy",str(int(mid([Pivot field names],2,1))*3-2)+str(right([Pivot field names],2)))
when "A" then [Date Convert]-10
when "B" then [Date Convert]
when "C" then [Date Convert]+10
when "D" then [Date Convert] end
if [F1]<>"D" then [Pivot field values] end
[Value D (single)]
if [F1]="D" then [Pivot field values] end
group_Bar_SM_9.3.twbx 32.1 KB