5 Replies Latest reply on Oct 14, 2016 8:09 AM by Shinichiro Murakami

    How to get a distinct count based on Other column(s)?

    Aashay Uppala


           I have a requirement where i need to do a distinct count of the values based on another column.



           1. Get the distinct count of teams for a particular team leader.

           2. Get the Distinct Count of Teams with more than three Instances (every team has one to multiple instance Id's) .


      Data will be grouped department wise. I have tried different ways but the counts are not accurate. Any kind of help is deeply appreciated.


      Please find attached the Excel data source along with the Tableau report.



      Thank You