What is the procedure for creating a confusion matrix in Google Looker Studio (formerly known as Data Studio)?

edit

The procedure for creating a confusion matrix in Google Looker Studio is not straightforward as there is no built-in feature for creating confusion matrices. However, it can be achieved through the following steps:

1. Export the actual values (true labels) and predicted values from the model into a CSV file.
2. Import the CSV file into Google Sheets.
3. In Google Sheets, use the COUNTIF function to calculate the number of true positives, false positives, true negatives, and false negatives.
4. Enter the counts into a table in Data Studio.
5. Use Data Studio's pivot table feature to create a confusion matrix by arranging the counts in the proper format.

Alternatively, there are third-party extensions available in the Google Marketplace that enable the creation of confusion matrices directly in Data Studio, such as the Confusion Matrix for Google Data Studio by Jivrus Technologies.