7 Replies Latest reply: Jun 9, 2015 11:07 AM by Ramon Covarrubias RSS

    Set Analysis - Get unique records

      Hi guys

       

      So in the table below, we have a maximum of 2 attempts to get a successful transaction per policy ID but not all first attempt failures are retried. I am trying to create a unique view that shows me distinct count of Policy ID's that were successful or unsuccessful as show in the second table. Please note that selections can still be made on the Success Flag on the sheet.

       

      Policy IDAttempt NumberSuccess Flag
      11No
      12Yes
      21No
      31No
      32No
      41Yes
      51No

       

      UnsuccessfulSuccessfulTotal
      325


      Your help will be greatly appreciated.