Hi Bryce! Can you share a packaged workbook with us? Or at least the formula in question?
Off the top of my head, I think you'd want to put a calculated field like this on the Labels mark and then format zeroes to be blank:
IIF(SUM([The Measure]) >= 0.03, SUM([The Measure]), 0)
The calculation to drive the initial heatmap (% of Weekly Boarders):
SUM([Boarder Hour])/SUM([Total Weekly Boarder Hours])
Custom label I created that lead to image 2 above:
IIF([% of Weekly Boarders]<.03,null,[% of Weekly Boarders])
My goal, if possible, would be to keep similar view as first image above but not display values displaying 0%-2%. I'd LIKE to be able to keep the boxes if they are not null.
Like this (created outside of Tableau, showing >=3%):
1 of 1 people found this helpful
Just to make sure, did you leave [% of Weekly Boarders] in the color mark? The custom label calculated field should go only in the labels mark. Can you take a screenshot of the whole Tableau application?
Ahhh. I had done that, but the sheet was set up with Marks as Automatic (went to Text). I've changed to "Square" and it's resolved!
Silly me. Appreciate the help. Clearly been too in the trenches building other aspects to think this through thoroughly!