My data are from Dec'23 until Feb '24. I have problems with showing the weekly data with a trend line.
The week numbers are 49, 50, 51, 52, 1, 2, 3, 4, 5, 6 - where 49-52 are from year 2023 and weeks 1-6 are from 2024.
Is there any way to show the trend line so the weeks would be next to each other 49, 50 ....5,6 - i.e. weeks 49-52 would NOT be pushed aside as shown below.
Notes to Tableau file:
- the trend line is required into Dashboard 'D weekly'
- the same issue is in Dashboard '12_31 view_12' with months across 2 years (not able to show trend for Dec'23, Jan'24, Feb'24). This tab shows last 12 months.
- tab 'weekly trend across years' shows how the trend line should NOT look like, this is what I need to resolve.
Would anybody be able to look into it please? I'm a beginner in Tableau...Thank you
Hi @Martina Lacikova
Unfortunately I can't use your workbook - a trick for the forums is to right click and extract your data source before producing exporting a packaged workbook from the file menu. However ... here is a suggestion demonstrated using sample superstore data...
If I have a view like this:
...where I used discrete week number with no year component:
I can instead select continuous week number with year...
And now I get this:
I could also right click the axis and select format to change back to week numbers in some form:
And if I rigth click the axis and edit, and then go to tick marks. Plus set the width in days on the Size button on the marks card, I can tweak to get more like this:
Let me know if this helps!
Ta, Steve.
