1 Reply Latest reply on Aug 4, 2017 5:18 AM by Michael Gillespie

    Filtering

    Sai Kiran

      Hi,

       

      I have the following requirement for my dashboard and I have no clue how to go about it...

       

      I have 3 values in my filter: (1) Include All  (2) Yes  (3) No

      - Upon selection of 'Include All' I need to display two columns in my table (Along with the other 5 columns in my table).

      - Upon selection of any other value in the filter the two columns should HIDE. (Showing only 5 columns)

       

      Request some help here...

       

      Thanks in advance.

        • 1. Re: Filtering
          Michael Gillespie

          You're going to have to think outside the box a little on this one.

           

          You can't show or hide columns based on a filter selection, BUT you can "swap and pop" visualizations on a dashboard using a parameter!  The idea is that you have 2 separate visualizations, one with 5 columns and one with 7 columns.  The parameter selection drives which viz appears in the dashboard.

           

          Start with this link and search the forums for more details.  It's a cool technique and the author(s) are on the forums all the time if you need help!

           

          We made a video of Sheet Swapping and Legend/Filter Popping on a dashboard.