11 Replies Latest reply on Apr 12, 2013 10:59 AM by kettan

    Slider question...

    Shawn Wallwork

      I don't work with sliders much, but I needed to use them yesterday. Does anyone know what that extra narrow bar indicates?

       

      Sliders.png

       

      Thanks

       

      --Shawn

        • 1. Re: Slider question...
          kettan

          I believe it indicates min/max range of underlying data.

          I guess it doesn't use the full range because some action filters are activated.
          At least that is one scenario I just tested to be true

          1 of 1 people found this helpful
          • 2. Re: Slider question...
            Shawn Wallwork

            Thanks Johan. That seems to be the case, but then why don't any of the other sliders have this same indicator. I can't figure out what makes this one different from the others. I've attached the workbook, maybe you can see what I'm missing.

             

            --Shawn

            • 3. Re: Slider question...
              kettan

              Why is minimum in slider less than minimum of filtered data?

              I think you found a bug, because the slider is not refreshed when we change [All Values in Database] to [Only Relevant Values].

              I came to this conclusion by changing Family w/ Kids Density from [All Values in Database] to [Only Relevant Values] and saw nothing happened until I moved the drawer toward right and than back as far left as possible.

              thread 125198 slider question.png

              Why has only one of the sliders a min/max range?

              I have found a pattern when the range indicator is displayed and when it is not.
              Slider filters show a min/max range when the measure is also on a shelf such as columns, rows, and detail.

               

              Ps. I am glad I got this rare opportunity to help a 10K+ helper, because they more than deserve it after doing an enormous effort for so many.

              1 of 1 people found this helpful
              • 4. Re: Slider question...
                Shawn Wallwork

                I'm starting to think it's a bug too. All the filters are also on the Detail shelf, so that's not it. They are also all set up the same way. So there just isn't a reason they should be behaving differently. At least not one I can think of. Oh well, not really important (at least not until the client asks about it)

                 

                --Shawn

                • 5. Re: Slider question...
                  kettan

                  All indicators are now seen. I did it by ctrl+ dragging all filters to the detail shelf.

                  I hope this earns me +4 points for correct answer which we helpers like so much

                  thread 125198 slider question - what I did.png

                  1 of 1 people found this helpful
                  • 6. Re: Slider question...
                    Shawn Wallwork

                    Sure as soon as you explain what you did to fix it.

                     

                    Never mind I figured it out. Thanks dude, here's your 4 points!

                     

                    --Shawn

                    • 7. Re: Slider question...
                      kettan

                      Thanks.

                      I guess this is no longer a bug, but a technical limitation in Tableau's design. Logically the min/max indicator should not depend on being included in details, because the range indicator should be a natural element of filtering.

                      1 of 1 people found this helpful
                      • 8. Re: Slider question...
                        Jonathan Drummey

                        Thanks for asking about this, Shawn, this was something that I'd wanted to explore a bit and hadn't taken the time to. I don't think this is a bug, this is a not-fully documented feature. The data bar is showing the range of data currently being displayed in the view.

                         

                        Here's a link to the docs on the "data bar":

                        http://onlinehelp.tableausoftware.com/v8.0/pro/online/en-us/help.htm#filtering_add_quick_options_quantitative.html

                         

                        However, Tableau has to know the range aka "domain" of data, and it doesn't for pills that are *only* on the Filters Shelf. (That's the undocumented bit). When a pill is on the Filters Shelf only it is not part of the view in the same way as on any other Shelf, Tableau only uses that pill in the WHERE clause in the query issued to the data source (and effectively as a WHERE/HAVING clause for filters that Tableau executes, such as for table calcs). For pills that are on the Rows, Columns, or Pages Shelves, or the Marks Card (i.e. the view), Tableau does load the domain and will display the data bar when that Dimension or Measure is also on the Filters Shelf.

                         

                        The key here is that the pills on the Filters Shelf and their counterparts in the view each have to have the same level of aggregation for the data bars to appear. What happened in Shawn's initial view is that all the Filters are Dimensions, while all of their counterparts on the Level of Detail Shelf are aggregated except for the Family w/Kids Density, so that's why that one gets the data bar. The reason why Johan's fix worked is that when he Ctrl+Dragged the copies, the same values were now on both the LoD and Filters Shelf and Tableau could display the data bars.

                         

                        Joe Mako  says the most important factor for understanding Tableau is to have pill awareness, i.e. what's a dimension/measure, discrete/continuous, and aggregate/non-aggregate, and (after a fair bit of personal struggle, suffering, and learning) I've come to agree with him. This is a case where even though we could see in the original view a green pill with Business Density on Filters and another green pill with Business Density on the LoD, the former pill is a dimension and the latter pill is actually SUM(Business Density), though in this case they return the same values Tableau treats them quite differently.

                         

                        Cheers,

                         

                        Jonathan

                         

                        PS: The data bars and displayed ranges can still get funky when we have multiple filters with Only Relevant Values showing due to the interaction between them, that's where I'd first run into this situation.

                        • 9. Re: Slider question...
                          Shawn Wallwork

                          Nicely explained Jonathan! Can't give you the green star because I already promised it to Johan, but you get 1 for explaining why all this is. Thanks,

                           

                          --Shawn

                          • 10. Re: Slider question...
                            kettan

                            Good explanation. Permission granted to give Jonathan the green star. The good feeling of helping you is luckily not lost by transferring the green star to a better explanation

                            Ps. I hope you remember to give me an orange star

                            1 of 1 people found this helpful
                            • 11. Re: Slider question...
                              Shawn Wallwork

                              Johan = 5 Helpfuls = 5 pts

                              Jonathan = 1 Correct = 4 pts

                               

                              Everybody's happy.

                               

                              --Shawn