1 of 1 people found this helpful
One option would be to create a calculated field similar to the following:
datename("month", [Order Date])+ " " + datename("year", [Order Date])+" W" + datename("week", [Order Date])
Though it loses the date functionality, it will get the desired view. You'll want to make sure to sort it by the date field.
Hope this helps!
Thanks for the response Tracy
But the user is very particular about the way the chart has to look, it is a lot tidier viewing the data in the grouped manner. Is there no way in Tableau to achieve the same manner?
You might try using a dual axis for the date. It isn't exactly what you you were looking for, but it's a little closer.
Dual Axis Date.twbx.zip 1.4 MB
Thanks for your answer Joshua, this is close