5 Replies Latest reply on Jun 22, 2016 9:59 AM by Michael Hesser

    Filtering as Hilighting

    andreea.banica

      Hello,

      I would have a question related to filtering in a Callan chart.

      I have a filter with Positive and Negative labels for the data in the Callan chart. Still, when I filter on Positive I want that the Callan Chart remains the same and only Highlights the Positive returns and shadows the Negative ones. Vice versa for negative values.

      Can I have this kind of filtering via highlighting only in tableau?

       

      Thanks

        • 1. Re: Filtering as Hilighting
          John Sobczak

          You can create a highlight action based on that dimension.

          • 2. Re: Filtering as Hilighting
            andreea.banica

            I already have a highlight for each index used. When I hover over one particular index it shows me the trend during the years.

            But I would like to have a filter so that I will not have to hover over for the highlight for positive and negatives because it will be very confusing for the viewer.

            I wanted to choose positive in a filter and see in the callan the positive ones highlighted without damaging the structure of the chart like a standard filter does.

            • 3. Re: Filtering as Hilighting
              John Sobczak

              If I understand what you are asking then this should be possible, but it is easier to understand and explain by way of a physical mocked up workbook.  Can you create one using the superstore sales?

              • 4. Re: Filtering as Hilighting
                andreea.banica

                Unfortunately I have never used this Superstore sales tool. I do not exactly know where it is.

                I am new around here.

                The table is simple: like below.

                And I would like the filter for Positive Negative in the Dashboard so that when I click on Positive the Callan has all the data in (in not filtering via exclusion) but the Positive ones are highlighted and the negative ones are a bit in the shade.

                 

                 

                 

                 

                 

                DateCatCategoryRank% ReturnPositivevsNegative
                12/31/2001BBB521.0000Positive
                12/31/2001AAA44.0000Positive
                12/31/2001EEE3-1.0000Negative
                12/31/2001DDD2-3.0000Negative
                12/31/2001CCC1-4.0000Negative
                12/31/2002BBB525.0000Positive
                12/31/2002AAA49.0000Positive
                12/31/2002EEE3-2.0000Negative
                12/31/2002DDD2-10.0000Negative
                12/31/2002CCC1-17.0000Negative
                12/31/2003CCC520.0000Positive
                12/31/2003DDD415.0000Positive
                12/31/2003BBB312.0000Positive
                12/31/2003EEE211.0000Positive
                12/31/2003AAA11.0000Positive
                12/31/2004AAA538.0000Positive
                12/31/2004EEE437.0000Positive
                12/31/2004BBB39.0000Positive
                12/31/2004CCC23.0000Positive
                12/31/2004DDD1-3.0000Negative
                12/30/2005DDD513.0000Positive
                12/30/2005CCC49.0000Positive
                12/30/2005BBB3-15.0000Negative
                12/30/2005EEE2-19.0000Negative
                12/31/2005AAA117.0000Positive
                12/29/2006AAA536.0000Positive
                12/29/2006BBB431.0000Positive
                12/29/2006EEE331.0000Positive
                12/29/2006CCC226.0000Positive
                12/29/2006DDD1-10.0000Negative
                12/31/2007DDD523.0000Positive
                12/31/2007EEE414.0000Positive
                12/31/2007BBB310.0000Positive
                12/31/2007CCC28.0000Positive
                12/31/2007AAA12.0000Positive
                12/31/2008BBB55.0000Positive
                12/31/2008CCC44.0000Positive
                12/31/2008EEE3-4.0000Negative
                12/31/2008DDD2-14.0000Negative
                12/31/2008AAA1-15.0000Negative
                12/31/2009BBB512.0000Positive
                12/31/2009AAA41.0000Positive
                12/31/2009CCC3-1.0000Negative
                12/31/2009DDD2-11.0000Negative
                12/31/2009EEE1-11.0000Negative
                12/31/2010BBB540.0000Positive
                12/31/2010EEE423.0000Positive
                12/31/2010DDD312.0000Positive
                12/31/2010AAA2-4.0000Negative
                12/31/2010CCC1-6.0000Negative
                12/30/2011CCC534.0000Positive
                12/30/2011DDD48.0000Positive
                12/30/2011EEE3-4.0000Negative
                12/30/2011AAA2-6.0000Negative
                12/30/2011BBB1-7.0000Negative
                12/31/2012DDD536.0000Positive
                12/31/2012CCC423.0000Positive
                12/31/2012AAA315.0000Positive
                12/31/2012EEE22.0000Positive
                12/31/2012BBB1-2.0000Negative
                12/31/2013DDD526.0000Positive
                12/31/2013BBB417.0000Positive
                12/31/2013CCC32.0000Positive
                12/31/2013EEE2-6.0000Negative
                12/31/2013AAA1-9.0000Negative
                12/31/2014DDD525.0000Positive
                12/31/2014CCC420.0000Positive
                12/31/2014BBB38.0000Positive
                12/31/2014AAA2-12.0000Negative
                12/31/2014EEE1-15.0000Negative
                12/31/2015EEE536.0000Positive
                12/31/2015BBB422.0000Positive
                12/31/2015AAA314.0000Positive
                12/31/2015CCC2-4.0000Negative
                12/31/2015DDD1-17.0000Negative
                • 5. Re: Filtering as Hilighting
                  Michael Hesser

                  Hello Andreea;

                   

                  Why not have multiple dashboard hover actions?

                  The first will highlight by [Positives Negative], the second will filter your trend line based on the dimensions you choose.

                   

                  If this is confusing to your user, why not set your colors using dual variables (I'm thinking [Cat], [Highlighter])?

                   

                  In this case Highlighter would be linked to a parameter, so that if the user chooses "Show me positive values" it's one value, and flip-flops it if the user chooses "Show me negative values". If the user chooses "(All)" then all values are highlighted.