11 Replies Latest reply on Jul 7, 2017 5:09 AM by Tom W

    Unique Searches Count

    sudheer.kumar.5

      In a table there are three columns; One - Source, Two - Destination, & Three - Search Id. The Search Id will be duplicated in case of Round Trip. Sample data is as follows:

      UniqueSearches.png

      I've tried with COUNTD(Search Id) and it is returning the Distinct Search Id. But I need the unique searches count, which is 3 (check the above image).

       

      Please help me to get the Unique Searches Count. It will be a great help.

       

      Let me know if you need more information.