Forum Discussion
Helper Icreate a new column for distinct values based on another column in matrix visual.
Hello experts,
I have been struggling to find a solution for this. I want to count a distinct value based on specialty.
I’ve got a table with some calculations as below.
Input:
SERVICE TYPE | Class Observations | Educators supported | ||||||
CASE TYPE | Project | Project1 | ||||||
APPOINTMENT TYPE | Observation at school | Educator Group Session | Staff Consult | |||||
APPOINTMENT TYPE CODE | OAS | EGRSE | SC | |||||
SPECIALITY | Occupational Therapist | Psychologist | Social Worker | Occupational Therapist | Occupational Therapist | Psychologist | Speech Therapist | |
SCHOOL (Care team) | MRN | Count of MRN | Count of MRN | Count of MRN | Count of MRN | Count of MRN | Count of MRN | Count of MRN |
Coutts Crossing Public School | 12345 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Total | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Expected output:
SERVICE TYPE | Observations |
| Educators |
| ||||||
CASE TYPE | Project |
| Project1 |
| ||||||
APPOINTMENT TYPE CODE | OAS |
| EGRSE | SC |
| |||||
SPECIALITY | Occupational Therapist | Psychologist | Social Worker |
| Occupational Therapist | Occupational Therapist | Psychologist | Speech Therapist |
| |
SCHOOL (Care team) | MRN | Count of MRN | Count of MRN | Count of MRN | Total | Count of MRN | Count of MRN | Count of MRN | Count of MRN | Total |
Coutts Crossing Public School | 12345 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
In short, I want to create a total column that can give me a distinct value for each service type (Observations, Educators etc…)
Any help would be greatly appreciated. Thanks in advance.
