counts and distinct counts

[#1]

Hello,

I have a group of analysts and want to see how many times they have mentored on a list of cases this year.  I want to build a table that shows their name, the number of cases they provided mentoring and lastly the number of times they mentored on each case.  Something like this:

Analyst	Cases	Touches
Bob Brown	26	57

The field names are:

NOTE_NAME and CASE_ID

thanks for any help provided!

[vishsaggi]

What are the expression you are using here? Did not Count(Case_ID) and Count(DISTINCT Case_ID) worked? Can you provide some sample data and expected output if possible. ?

[vinieme12]

dimesion

Analyst Name

Expressions

Cases: Count(Distinct NOTE_NAME)

Touches: Count(CaseID)

[#4]

I tried these two expressions and ended with the same values:

[vinieme12]

It'll be easier to assist if you post some sample data

Preparing examples for Upload - Reduction and Data Scrambling

[vinieme12]

or maybe they actually mentored each case only once