Firstly, we cannot open the attachment as the datasource is not extracted and it's not been uploaded as a Packaged Workbook.
Regarding your issue, it's likely you will need to include some placeholder / faked sample data into your datasource in order to force November / Q4 to show up. That's how I normally solve this problem.
I have replaced the file with a .twbx file instead so should contain the views that explains my issue.
Unfortunately I'm pulling data in from a real-time environment with real case problems in a Greenplum environment. I also don't have access to edit or write to this database but even if I did it would be eliminated with our data quality clean-up tools.
I'm just very surprised that it's not so simple to display KPIs in a dashboard that have gone to 0 for the most recent time period.
In my case, it's basically displaying the 'two recent Qtrs of figures that have data' rather the 'two recent Qtrs of figures'
So while Tableau does have functionality (the "Show Missing Values") to pad out a field, this only works for "Range Aware Pills" (these are either Dates or Bins, where Tableau knows the MIN, MAX and increment of the field). This means it can only "pad" from MIN to MAX. If it didn't do this...when would Tableau know when to stop!...2017, 2018...2040?
Jonathan Drummey has created this idea...https://community.tableau.com/ideas/1796
where the user could define the MIN/MAX they want, that you might like to vote up. In the meantime it does need the MAX (you want) in the data...it only needs to have one row (so if your data team, can create a table with a single row...with just today() in the date field, and then union this to your data that would be enough that you could use Tableau's inbuilt padding.
Hope that helps
Wow...clever stuff Lukasz!!
I'll need a bit of time to digest exactly what's going on here, but great work!
I like the idea of this but just cant seem to open the .twbx file to see how you've done it
I saved it with tableau 9.3. You may convert to your version by modifying
xml but I will be away from my laptop tonight so maybe others can help
okay thanks Lukasz.
I'm working on a 9.2.9 and can't upgrade any further since I need to keep it compatible with our Tableau server.
If someone could attach a version that I can open, it would be great :-)
Thank you VERY much Lukasz and Alexander!
I finally had the time to try out this solution for myself and replicate it.
I must still get my head around how it works but it does definitely does work
Thank you!! :-)