Could you kindly share your Tableau workbook with dummy data for getting appropriate solution.
I faced this issue myself on a recent project. I have good news and bad news and great news..
The bad news:
Tableau generally can't show data that isn't there in the data set. So if your survey responses are 1-5, and no one responded 3, Tableau does not (natively) draw a mark at zero for answer 3.
The good(-ish) news:
The way to solve this is with a data scaffold. There are a number of good blogs on the topic. While scaffolds are commonly used for dates (to ensure you show at least zero sales for every possible date), they will also work for a survey (to make sure you show at least 0 responses for answers 1 through 5).
The great news:
At the Tableau conference this year (TC19), Tableau announced that they are completely revamping the way data models work. Instead of a very rigid right/left/inner join model, they are going to make it a native, flexible model where you build all the possible associations that work for any level of detail, and Tableau picks the appropriate ones to use for each viz. This is closer to the associative model that Qlik Sense uses. It was announced (I think) in Devs on Stage, though it's shown in more detail in this talk:
I've seen the 2020.1 beta, and this enhancement is not in that one. But keep your eye out for it later in 2020, if we're lucky.
THANK YOU much for the very detailed and helpful response!!!
I am trying to follow instructions from The Flerlage Twins blogpost on "Creating a Scaffold in Desktop" with a spreadsheet of my own but am running into issues...
Any possibility that you can help me troubleshoot? Attached is my packaged workbook and spreadsheet (I think the issue might be stemming from the left outer join in the very last step, but can't seem to figure it out).
Many thanks again
In this case, Zahra, your "scaffold" will need to contain every possible combination of Clerkship, Academic Year, and Response. You need to do a cross-product (also called a cross-join or Cartesian Join). So your scaffold will consist of 2 x 3 x 5 = 30 records.
You can create each of these as a separate tab in Excel, and then join them in the Tableau data model with the Custom Join statement 1=1.
Then you will outer-join your original data to this 30-row scaffold. That way, even if a response was never selected, it will have a row with null in the data.
In the workbook, create a new field called [Number of Responses]:
if not(isnull([Value])) then
You can now sum [Number of Responses] to get a zero where no one used that response. You can show this as a crosstab or in a bar chart. Remember that you will need to use Value_Scaffold (the response that is always there) as your dimension on rows or columns.