Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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. ?
dimesion
Analyst Name
Expressions
Cases: Count(Distinct NOTE_NAME)
Touches: Count(CaseID)
I tried these two expressions and ended with the same values:
It'll be easier to assist if you post some sample data
Preparing examples for Upload - Reduction and Data Scrambling
or maybe they actually mentored each case only once