1 Reply Latest reply on Aug 15, 2012 10:19 PM by Jonathan Drummey

    Hide points but don't exclude data

    Casey Dagnall
    Casey Dagnall Aug 15, 2012 11:57 AM

      Is there a way to hide data points, but not exclude them from calculations for reference lines used, specifically for box plots I'm attempting to generate.

       

      See attached screenshot of worksheet.

      I want the circles outside of the boxes to remain visible, but for the points which fall inside the boxes to be covered (not seen).

        • 1. Re: Hide points but don't exclude data
          Jonathan Drummey
          Jonathan Drummey Ambassador Aug 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