27 Replies Latest reply: Sep 20, 2016 7:29 PM by Sunny Talwar RSS

    Issue with Counting Distinct

    Ryan McClellan

      Hello,

      I am trying to count distinct 'Call: Call ID' using set analysis. I have include the script I am using below. However, when I use this method, I am missing about 30 records from the data set. I have confirmed that there should be 241 records returned but I am only getting 210. Is there something wrong with my script? Any other suggestions as I am stuck...

       

      Thanks.

       

      Count(distinct{$<[Liason Type]-={'FME','AML'},[Product: Description]={'Apples'},Objective-={'Presentations'}>} [Call: Call ID])