2 Replies Latest reply on Dec 17, 2013 7:26 AM by Matt Lutton

    How do I filter without loosing data?

    Tom White

      Hey Everyone,

       

      I'm sure this will be a snap for most of you...

      Lets say I have a group of software testers, and I want to return their 'pass/fail' as a percentile - while only keeping the people who have failed code. In this case I want to display only "John" without filtering out his passes. His percentile should read Pass: 90.91% Fail: 9.09%

       

       

      Resouce NameStatusNumber of Records
      JoePassed11
      MarkPassed11
      JohnPassed10
      JohnFailed1

       

      Thanks,

       

      Regards,

      Tom White

       

      Message was edited by: Tom White Sorry, I'm new at this hole thing - as you can probably tell by the major update to my data format...

        • 1. Re: How do I filter without loosing data?
          Matt Lutton

          This would be simpler to do with reshaped data.  Notably, your Passed/Failed Columns could be combined into one column with a row identifier for Pass/Fail.  The percentages would be easier to do in Tableau with the data in this format.

           

          To filter for only John, you can create a calculated field like:

          [Failed]>0

           

          Place that on the filters shelf, and only John will remain and both his pass and fail numbers will be returned.

          1 of 1 people found this helpful
          • 2. Re: Re: How do I filter without loosing data?
            Matt Lutton

            Using the data you provided, we can still get the results you want.  See attached.  With the data in this format, a total measure had to be created, which is equal to your Failed + Passed fields.  Then, the failed or passed fields must be divided by the total to get your percentages. Example attached.  Note that the "Clipboard" data source was created by simply opening Tableau 8.1 and copying and pasting the data you placed in this thread.