Hi Tableauers,
I have on my hands a Workbook that contains Sales data for all Weeks in 2018. This data is coming from an Excel sheet. Every week, new rows are added to this sheet, thus adding data for another week.
Unfortunately, even though the Sheets are set up in a way that new weeks' data is supposed to be added to the viz and thus update the dashboards, this does not happen.
In the picture below:
I had until today data only until Week 23 (value: 495). After updating the data source with Weeks 24 and 25, nothing has changed in my Workbook.
You see below that only the value for W23 appears, even though I filtered the Weeks to show W24 and 25 as well.
What's odd is that when removing the Week pill from the Columns and inserting it back in, the added Weeks do appear.
This is not a viable solution as the workbook is meant to be as automated as possible, and there's a considerable amount of sheets that would all need to be worked on every week.
Any help is greatly appreciated!!!!
Thanks in advance:)
BestSebastian
Hi guys,
Just noticed that on the week pill I can click on 'Show Hidden Data' which makes the new weeks appear.
Do you know why? And how to automate this so the new weeks are automatically shown?
Thanks!!!
