'Is there a way to count the number of a certain value across multiple columns (fields) in Google Data Studio

I can easily do this in Excel with a formula like:

=COUNTIFS(F:F,"=5") + COUNTIFS(G:G,"=5") + COUNTIFS(H:H,"=5")

But in Google Data Studio I can only get this to work on a per-column(field) basis.

The data structure looks like this:

enter image description here

I want to count the total number of 1s, 2s, 3s, 4s, and 5s across the People, Process, and Technology columns in Data Studio and display in a pie/circle or bar chart that shows the total number of each as a data point.

google-data-studio


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions