I have a data set with 2 dimensions - "Date" and "Source". But I don't have all of the sources in each date.
2016-07-25 - Source A, Source B
2016-07-24 - Source B
2016-07-23 - Source A, Source B, Source C
2016-07-22 - Source A, Source C
2016-07-21 - Source A
My Measures comes from a different data set - so I DO have a value for each source in each date (but in the others data source the names don't match to how I want them to be in the view).
Is there a way to show a constant list as a dimension so I could see all the options?
Example for how I want it to be:
2016-07-25 - Source A, Source B, Source C
2016-07-24 - Source A, Source B, Source C
2016-07-22 - Source A, Source B, Source C
2016-07-21 - Source A, Source B, Source C
Your best option is to create a datelist within excel and then join both datasources to the excel datasource.
Hope this helps if you have any further question or require assistance in setting this up please let me know
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...