Correlation Matrix Not Available

Solved!
sdfungayi
Level 3
Correlation Matrix Not Available

I want to perform correlation matrix analysis on a dataset but all the fields are greyed out and not available, making it impossible to do the analysis.

I was expecting to be able to select fields for use in the analysis, but DSS greys out all the fields immediately I enter the "Correlation matrix" window.

What could I be missing?

See attached image

 

Fields not available.JPG

2 Solutions
Clรฉment_Stenac

Hi,

The Statistics capability in DSS relies on the storage type of the columns to know if they are numerical or categorical. Only numerical columns are eligible for correlation matrix. At the moment, all your columns are categorical (i.e. "string")

You have two options:

* Use a prepare recipe to create a new output dataset with types infered from the input
* Or go to the Settings of the dataset, then go to Schema, click on "Check now" then on "Infer types from data" in order to compute storage types that match your data

View solution in original post

sdfungayi
Level 3
Author

I tried both options. They work perfectly.

Thanks

View solution in original post

2 Replies
Clรฉment_Stenac

Hi,

The Statistics capability in DSS relies on the storage type of the columns to know if they are numerical or categorical. Only numerical columns are eligible for correlation matrix. At the moment, all your columns are categorical (i.e. "string")

You have two options:

* Use a prepare recipe to create a new output dataset with types infered from the input
* Or go to the Settings of the dataset, then go to Schema, click on "Check now" then on "Infer types from data" in order to compute storage types that match your data

sdfungayi
Level 3
Author

I tried both options. They work perfectly.

Thanks