1 of 1 people found this helpful
Can you please provide us a sample workbook so that we can provide you solution according to your data set.
Generally Tableau shows data which is presented in your data source only. Tableau will not going to show your data source which is not present but if you want to show them then you will have to do that before you connect Tableau to your data.
There are a few options to help you pad your data with null values:
- Use a data blend, with the primary data source one that has every possible combination of dimensions that will make a mark, then if there is a value missing in your data source, a null value will be placed.
- Use Custom SQL, varies by situation, could be a UNION, and/or a CROSS JOIN to generate the combinations of data that you want.
Check the attached file in which I have used two data source to fulfill your requirement. Hope this may help!
Yes these methods fulfill some requirements, but can you please provide us all the requirements in this worksheet, so that we can work according to that. Every tool is having some limitation. How can you show the data which is not present in your database? You can use custom SQL also. If you want to show the result according to your requirement, you can put Name after Quarter.
Hope you can understand!