4 of 4 people found this helpful
Here are a couple of options:
1) If the data source supports Tableau's union functionality then you can use the union to create a new date dimension and a new measure that use the duplicated data. I set that up in the attached workbook in the union sheet.
2) If the data source doesn't support the union functionality then there are a few options:
a) Create a "scaffold" data source that has a record for all dates (and ideally dimensions you want to filter on) and then use that as the primary source in a Tableau data blend with the secondary source your actual data, then a couple of calculated fields. I set that up in the blend sheet in the attached workbook.
b) If the date source doesn't support union functionality you can get a union effect in Tableau using a cross data source join, see Cross Data Source Joins + Join on Calcs = UNION Almost Anything in Tableau v10.2 | Drawing with Numbers for more details.
c) If the data source supports Custom SQL (if you're using MS Excel or text then you'd need to use the legacy connector) you can write a SQL query to add the extra row via a union or join to another table.
Let me know if you have any questions!
1 of 1 people found this helpful
Thank you for your response. We recently upgraded our server environment to 10.2 and I was able to leverage the union functionality. I appreciate it.