1 Reply Latest reply on Jan 31, 2017 8:22 AM by Shinichiro Murakami

    Need help setting up a custom filter

    Shakaib Ashraf

      Hello Everyone,

       

      I thought I might as well try here where I've been stuck for a while. I'm trying to setup a filter that filters specific values. My data looks like this,

       

      ID
      ValueCount
      1Submitted1
      2Not Submitted1
      3Submitted1
      3Not Submitted1
      4Submitted1
      5Submitted1
      6Not Submitted1
      6Submitted1
      7Submitted1

       

      As you can see, I'm trying to count the values "Submitted" and "Not Submitted" based on their IDs. However, there are instances where the same ID has both values which makes it a duplicate entry. In this case, I would like to only count the "Submitted" value and exclude the "Not Submitted". However, I would like to measure all other "Not Submitted" which are not duplicates. Any help with this would be much appreciated.

       

      Thank you!

       

      Shakaib