If the values in the datasource are NULL and you are using a date you can hide the NULL values by going to Analysis -> Special Values -> Hide
Unfortunately, I do not have a "Special Values" command on my Tableau - is that a feature for Tableau 7? I'm on 6.1...
Also, it's not just null values I want to hide, I also want to hide values where there is not a full weeks data....
I'm wondering if there is some sort of exclusion based on a criteria?
Anyone able to help out with this????
Thanks Mate - you are a star!
P.S. To get rid of data where a full week hasn't passed, I added a condition to the metric so it displays null.
IF COUNTD([thedate]) = 7 THEN(sum([num_visits])-sum([insite_visits]))/7000000 ELSE NULL END