2 Replies Latest reply on Feb 21, 2013 8:17 AM by Jill Reid

    Mixing Global and Local Filters

    Jill Reid

      Hi All,

       

      I am working with some dashboards that feed off of a global filter. For simplicity's sake, I will say the global filter lets the user select one>many letters of the alphabet. This part of the filter works just fine. However, I now have one dashboard that I would like to always display A, B, C (my end user plans to always have these selected) and then display an "Other" column that groups the rest of the selection (no matter what they are, if there are any).

       

      That is to say, for the selection "A, B, C, D, E, F"

      My first few dashboards will display A, B, C, D, E, F

      But I want my last dashboard to display A, B, C, Other

       

      Does anyone have any suggestions? I am trying to create calculated fields, etc. but nothing seems to be working.

       

      Thanks so much in advance!

      Best,

      Jill

        • 1. Re: Mixing Global and Local Filters
          Shawn Wallwork

          Hi Jill, welcome to the forums! You can do this by duplicating your data source, and then using the duplicate to create the second dashboard. Global filters are global to all worksheets using the same data source. By using the duplicate data source you avoid these global filters. BTW, this will change next month when V8 is released. Then you will be able to assign global filters to some sheets and not others.

           

          --Shawn

          • 2. Re: Mixing Global and Local Filters
            Jill Reid

            Hi Shawn,

             

            Thanks for your reply.

             

            I have done what you suggested for other use cases-- however in this case, I still want the global filters to apply to this dashboard. Essentially I need my last dashboard to locally filter on global filter results.

             

            Based on the global filter, I want this dashboard to:

            Show "A", if it is selected.

            Show "B", if it is selected.

            Show "C", if it is selected.

            For any additional letters selected, group and show them as an "Other" category.

             

            Does this sound like something that is at all feasible? I have provided a few more example below.

             

            For the selection "A"

                 My first dashboards will display "A"

                 My last dashboard will display "A"

             

            For the selection "A, B, C"

                 My first dashboards will display "A, B, C"

                 My last dashboard will display "A, B, C"

             

            For the selection "A, B, C, D, E, F"

                 My first dashboards will display "A, B, C, D, E, F"

                 My last dashboard will display "A, B, C, Other"

             

            Your feedback is greatly appreciated!