-
1. Re: Hide points but don't exclude data
Jonathan DrummeyAug 15, 2012 10:19 PM (in response to Casey Dagnall)
Hi Casey,
The general way to do this is to set up a table calculation that will flag the desired marks, and put that calculation on the Filter Shelf. Filters based on table calculations are performed after most all other calculations are completed, so they effectively hide results without changing them.
One caveat is with regards to Tableau's built-in reference line calcs, which it appears that you are using from the screenshot. Those built-in computations are performed after table calc filters are applied (see this post for details: http://community.tableau.com/thread/113542#comment-39603), so that would exclude the "hidden" values from being used in the reference lines. The workaround is to build your own calculations that duplicate what you want Tableau to do, put those calcs on the Level of Detail shelf, and use those for the reference lines instead.
Jonathan