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

    Unique Searches Count


      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:


      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.