6 Replies Latest reply on Aug 25, 2016 12:09 PM by Colby Gogan

    Combining multiple filters

    Colby Gogan

      Hi,

       

      I have 4 different filters with 4 different data sources in tableau.  These filters measure either a pass or fail for each set of data.  What I am trying to do is create one filter where I can create a drop down menu and select the data that have failed 1, 2, 3, or 4 of the different data sources.  At the moment all of these filters are separate.  Hope I explained that clearly enough.  Thank you!

       

      Currently:

       

      Data Source 1 - Filter options "Pass" or "Fail"

      Data Source 2 - Filter options "Pass" or "Fail"

      Data Source 3 - Filter options "Pass" or "Fail"

      Data Source 4 - Filter options "Pass" or "Fail"

       

      What I am looking to create:

       

      Failed Data Sources - Filter options "1 Control Failed" , "2 Controls Failed", "3 Controls Failed", "4 Controls Failed"

       

      Thank you!

      Colby

        • 1. Re: Combining multiple filters
          Vincent Baumel

          Is there any way you could attach a workbook or sample data set? Filters don't really measure anything, they either allow or restrict the data you can see. I'd need to see how your Data Source filters are currently set up to figure out the right calculation for you.

          • 2. Re: Combining multiple filters
            Colby Gogan

            Hi Vincent, thanks for your quick reply!

             

            Unfortunately I can't share the data.  Below is an example:

             

            Data Source 1:

            Column: Server Compliance

            Filter: Fail

            Value: # of Applications

             

            Data Source 2:

            Column: Vulnerability Compliance

            Filter: Fail

            Value: # of Applications

             

            Based on these 2 data sources, I am looking to create a master filter where you can select "1 Control Failed", or "2 Controls Failed" and it would display the number of applications that have failed 1 or 2 of the controls.  The controls in this case is server compliance and vulnerability compliance.

             

            Thanks,

            Colby

            • 3. Re: Combining multiple filters
              Vincent Baumel

              Can you describe your data? Is each row a specific application, and the pass/fail a column like the compliance tests? Also, it will help to know which version of Tableau you're using. Tableau 10 introduced the ability to filter across multiple data sources, so that might be relevant in this case.

              • 4. Re: Combining multiple filters
                Colby Gogan

                Yes exactly, so the format is like this:

                 

                Overall Compliance (Source 1/ Control 1)

                 

                App Code         Overall Compliance

                1234                 Fail

                1235                 Fail 

                1236                 Pass

                 

                Vulnerability Compliance (Source 2/ Control 2)

                 

                App Code         Vulnerability Compliance

                1234                 Fail

                1235                 Pass

                1236                 Fail

                 

                Tableau version is 9.3                               

                • 5. Re: Combining multiple filters
                  Vincent Baumel

                  The solution I could come up with is probably pretty clumsy, but I put together a sample workbook with 4 different data sources. Maybe someone else could use this to come up with a solution. Any way, I hope it helps you get your answer!

                  1 of 1 people found this helpful
                  • 6. Re: Combining multiple filters
                    Colby Gogan

                    Thanks Vincent, much appreciated.  The solution is very close.  I just need to find a way to aggregate the number of Fails from each column...