Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I plotted data from patients those have a diagnosis and each diagnosis has a score. There are 25 patients those can have 1 main diagnosis and 1 or more sub diagnoses. At least one main diagnosis and 1 sub diagnosis is obligatory. There are 7 different diagnoses in this dataset and each diagnosis has a certain score per patient. I want to make a bar chart that has the 7 different diagnoses and all of the individual scores plotted. The problem that I have is that double scores aren't plotted, only distinct values are shown in this graph. The graph that I have currently is:
The data to plot is:
DiagnoseId | PatiëntId | DiagnosePatiëntType | DiagnosePatiëntScore |
Addiction | 001 | Sub | 9 |
Addiction | 003 | Sub | 12 |
Addiction | 009 | Sub | 6 |
Addiction | 010 | Sub | 9 |
Addiction | 011 | Sub | 11 |
Addiction | 013 | Sub | 10 |
Addiction | 015 | Sub | 12 |
Addiction | 019 | Sub | 10 |
Addiction | 023 | Sub | 11 |
Addiction | 024 | Sub | 9 |
Addiction | 025 | Sub | 12 |
Anxiety | 002 | Sub | 10 |
Anxiety | 004 | Sub | 10 |
Anxiety | 006 | Sub | 9 |
Anxiety | 007 | Sub | 12 |
Anxiety | 011 | Sub | 11 |
Anxiety | 015 | Sub | 11 |
Anxiety | 016 | Sub | 9 |
Anxiety | 017 | Main | 8 |
Anxiety | 020 | Main | 11 |
Anxiety | 022 | Sub | 11 |
Depression | 001 | Main | 11 |
Depression | 002 | Main | 8 |
Depression | 003 | Main | 8 |
Depression | 005 | Main | 8 |
Depression | 006 | Main | 10 |
Depression | 007 | Main | 8 |
Depression | 008 | Main | 10 |
Depression | 009 | Main | 14 |
Depression | 010 | Main | 10 |
Depression | 011 | Main | 10 |
Depression | 012 | Main | 9 |
Depression | 013 | Main | 11 |
Depression | 014 | Main | 12 |
Depression | 015 | Main | 11 |
Depression | 016 | Main | 10 |
Depression | 017 | Sub | 14 |
Depression | 018 | Main | 11 |
Depression | 019 | Main | 8 |
Depression | 021 | Main | 11 |
Depression | 022 | Main | 10 |
Depression | 023 | Main | 10 |
Depression | 024 | Main | 10 |
Depression | 025 | Main | 14 |
Other | 005 | Sub | 13 |
Other | 014 | Sub | 12 |
Other | 018 | Sub | 11 |
Other | 020 | Sub | 11 |
Other | 025 | Sub | 10 |
Personality disorder | 008 | Sub | 10 |
Personality disorder | 018 | Sub | 8 |
Personality disorder | 025 | Sub | 12 |
PTSD | 005 | Sub | 8 |
PTSD | 012 | Sub | 8 |
PTSD | 018 | Sub | 14 |
PTSD | 021 | Sub | 10 |
Somatoform disorder | 002 | Sub | 10 |
Somatoform disorder | 004 | Main | 15 |
Somatoform disorder | 011 | Sub | 10 |
Somatoform disorder | 022 | Sub | 11 |
As example: 'Addiction' is diagnosed for 11 patients so the bar chart needs to contain 11 bars for addiction. However only 5 bars are shown because there are 5 distinct values for 'Addiction'.
Something like this?