cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Passion2learn Frequent Visitor
Frequent Visitor

COUNTING NO. OF TIMES A DISTINCT VALUES OCCURS IN A COLUMN

IMG_20171122_212444_HDR.jpg

 

IMG_20171122_135241.jpg

 HERE FIRST TWO COLUMNS ARE THE TOTAL COUNT , WHILE THE THIRD COLUMN IS NO. OF TIMES UNIQUE INBOUND & UNIQUE OUTBOUND CALLS .. WHICH IS GREATER THAN THE TOTAL .. PLEASE HELP I AM NOT ABLE TO FIGURE OUT HOW TO CORRECT THIS

 

3 REPLIES 3
Passion2learn Frequent Visitor
Frequent Visitor

COUNTING NO. OF TIMES A DISTINCT VALUES OCCURS IN A COLUMN

IMG_20171122_212444_HDR.jpg

 

IMG_20171122_135241.jpg

 HERE FIRST TWO COLUMNS ARE THE TOTAL COUNT , WHILE THE THIRD COLUMN IS NO. OF TIMES UNIQUE INBOUND & UNIQUE OUTBOUND CALLS .. WHICH IS GREATER THAN THE TOTAL .. PLEASE HELP I AM NOT ABLE TO FIGURE OUT HOW TO CORRECT THIS

 

stretcharm Senior Member
Senior Member

Re: COUNTING NO. OF TIMES A DISTINCT VALUES OCCURS IN A COLUMN

You can change counts to count(Disctinct) from the menu on the Value for the table fields.

It's also possible to change the default summarization to count(Distinct)

 

Passion2learn Frequent Visitor
Frequent Visitor

Re: COUNTING NO. OF TIMES A DISTINCT VALUES OCCURS IN A COLUMN

That is what i am using Count(Distinct) for calculating count of unique values in the 3rd Column .. But it is not giving the correct values .. The problem above remains the same.