Ask Your Question

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

asked 2022-08-26 11:00:00 +0000

nofretete gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2022-05-24 03:00:00 +0000

huitzilopochtli gravatar image

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.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer

Question Tools


Asked: 2022-08-26 11:00:00 +0000

Seen: 9 times

Last updated: May 24 '22