Yeah, I tried to cheat with just the screen shot. Since I can't share the actual data I have to create dummy data and re-create the worksheet; kind of a painful process.
I'm attaching an example workbook as well as the underlying Excel dummy data I used. I'm fairly certain the structure of the hierarchies is confusing Tableau somehow but I don't know why and I'm not sure how to correct it. It's not ideal but this is how the data is delivered to me from a SAS modeling process, just trying to make it work. As you can see in the example workbook the same problem is occurring. I'm using a calculated field as the lone measure, and using the red-green diverging color scheme. The mid-point is a somewhat arbitrary 10% (0.10) but it shows the same behavior: the NULL cells are treated as 0 and therefore have the darkest red coloring. These fields should be empty (i.e., white). The user controls on the right-hand side allow you to change:
- The attribute (either Category or Size)
- The measure (either Units or Dollars)
- The hierarchy level (Level 1, Level 2, or Level 3)
Let me know if this helps and if there are additional questions. Thanks.
I doubt I ever would have found that. Works great, thanks for the help Shawn!
Shawn, that is a different computation result than what John provided.
The compute using prior to using the Show Me button was Table Across, or User - Hierarchy.
Your settings that you suggest is effectively Table Down and Across.
The real situation that John has experienced here, is the result of using the Show Me button with a table calc pill in play.
When you use the Show me button, Tableau 'locks' settings in, both enabling views not able to produce in the user interface, and causing unforeseen results like this situation, where the data is padded.
I believe a better solution is to remove the table calc pills from the shelves after performing the Show Me, and then placing them again. This way you do not get the side-effect of the Show Me impacting your results.
See the attached, each sheet i added is one step in the process that I would recommend.
example_119211 jm edit.twbx.zip 23.2 KB
Thanks Joe. I had noticed the table calc changes/errors after I went through some testing and wasn't sure if I had been doing something wrong when building this out. Your answer helps a lot; I didn't realize the Show Me feature had this effect.
I tried implementing this on my end (in my production version) and didn't come out with the same results. I see very clearly where after I use the Show Me button and then remove the table calc pills that I get Tableau to start behaving correctly: there are NULLs (uncolored) in cells where there are no corresponding rows in the data set, and because the Size shelf is still populated with "One (generated)" I see the remaining cells are colored with the default blue. But when I add back the table calc field to both the Color and Label shelves I get the same behavior as before: Tableau is forcing the NULLs to zero. (Plus my table calc is wrong.)
No need to keep digging in, your example works perfectly so I just need to spend more time understanding that version and applying it to my production version. Thanks again for the help.