1 of 1 people found this helpful
The problem here is semantically a distinction in terms. You are referring to Null data, but there is a distinction to be made between Null and non-existent. You are asking Tableau to show a value. Tableau visualize and manipulate existing data, but cannot populate a row which does not exist. A proper Null value would be a row with some columns filled in, and the field you are trying to use having an empty cell for that row, but this data set does not have such a structure.
Thanks for your explanation and clarification. I have updated the topic of my question to reflect your answer.
Is there any way to systematically 'pad out the underlying data' so that I can get the end visual we desire?
Ben is correct basically.
However, If you are OK to add couple of steps, please follow below procedure.
I am proposing the Data structure change in Tableau itself.
Create table like this.
zn(lookup(sum([Number of Records]),0))
Then copy worksheet's data and paste.
You can see new data source as "clipboard******"
From the new data source, create new worksheet.
NullDataProblem_9.3.twbx 16.9 KB
Thanks for your thorough explanation Shin. This solved my issue and enabled us to create the Viz we desired.