Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I’ve got a dataset which contains a list of patients some of whom may have admissions for Asthma, Diabetes, Epilepsy, etc.
I’m trying to create a matrix or grid to show total patients not simply for each of these conditions but a total where there may have been an admission for more than one condition. So for example in the table below, 5 patients have had admissions for Asthma only but 1 patient has
had an Asthma admission and also a previous admission for Diabetes.
Asthma Diabetes Epilepsy
Asthma 5 1
Diabetes 2
Epilepsy 1
Can this also be displayed as a bubble chart?
Thanks for your help
Hi,
You can do it by creating another link field for the conditions.
Data:
LOAD * INLINE [
Patient, Condition, Visit
1, Asthma, 1
2, Diabetes, 1
3, Asthma, 1
1, Epilepsy, 1
5, Asthma, 1
1, Diabetes, 1
];
DataMatrix:
LOAD
Patient,
Condition AS ConditionMatrix
Resident Data;
You will get an idea on checking the attached file