Matrix problem

[#1]

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

[CELAMBARASAN]

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