Is there a way to show a blank field as a zero? I have two columns (Yes and No) that are displayed as percentage. I only want to see % Yes. There are rows that are 100% No. When I hide No the row disappears. I want the row to have 100% No and 0% Yes. This way when I hide No the row still shows with 0% Yes.
Try wrapping your calcs in ZN(), this should turn NULLs to zeros depending on the exact situation.
This NULL handling and formatting business has been lacking for a long time now, I believe there's an idea for it - certainly being able to format() items verses affecting their data or data type.
For example, showing NULLs as simply blank. If it's a number, a blank is an empty string so datatype is affected.
Hmm, I was looking for a way to show NULL as blank for display purposes only. It appears that is not possible. Makes for a cluttered display if a lot of NULL values exist.
You could set NULLs up to be white (or same color as bg).
That should work. I've done that in Excel in the past but it didn't click that I could do the same in Tableau. Thanks!
If you have time, can you provide a general description of how to set NULLs to white.
Put on the color shelf. You could also probably just take whatever field is producing your values in your viz and stick this on the color shelf. Then manually set the NULL to white (double-click the NULL in the color legend, then double the NULLs in the dialog box that pops up and pick white), you'll then have to change all your other % values to black by hand if this is a text table. So the first option is easier.