Community Conundrum 28: News Engagement is live! Read More

Correlation Matrix Not Available

Level 2
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 Replies
Dataiker
Dataiker

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

Level 2
Author

I tried both options. They work perfectly.

Thanks

Labels (2)