Hi guys I am a rookie and I have a problem i need help with. I am trying to color code columns to represent Age Group. However the cells that are not associated or cells that do not have relevant data are also getting colored.
For eg Category Izvie only has data with values Elementary or Primary under Column Age Group but the cells under High and Super high are also filled w color. I want these 2 cells, for eg. to be blank. How can I do that
Basic overview on what I am trying to measure:- I am just distinct counting ID Column and show it by Main category, Sub Category, Category and Age Group.
Attached is the tableau file. I have looked at many videos and tried to solve it with an ATTR() field at column level but could not. I hope I can get some help.
Please see if this is what you are looking for
I have also edited by Preferences file to get the colors you are looking for
Location of the file "Preferences.tps" : C:\Users\<userName>\Documents\My Tableau Repository
Add the following to the file
<color-palette name="Customized 6 color Palette" type="ordered-diverging">
<color>⌗FFFFFF</color>
<color>⌗3498DB</color>
<color>⌗229954 </color>
<color>⌗F7DC6F</color>
<color>⌗873600</color>
<color>⌗E74C3C</color>
</color-palette>
Thanks
Madhuri
