CODEWITHSUNDEEP
looker-studio
aabujamra
aabujamra

Reputation: 4636

Make the variable to be shown in the chart customizable

I have a Google Sheets dataset and I'm creating a Google Data Studio report out of it (and I'm a beginner). I need to create 3 filters, similar to this I did on Google Sheets:

enter image description here

First and second are alright, just adding the filter and selecting the metric. However the third one should select the metric to be analyzed in my chart, so it gets to look like this:

enter image description here

And the metrics to be analyzed are the ones in yellow in my sheets database: enter image description here

If I understood correctly I need to leave dimension as customizable variable to the user among a set of variables.

Is there a way to do that?

Upvotes: 3

Views: 235

Answers (2)

aabujamra
aabujamra

Reputation: 4636

I didn't find a proper way to do that in Google Data Studio. The best way I found was to add an Optional Metric chart by chart. It is not ideal because I wanted a single metric filter for all charts.

enter image description here

Upvotes: 2

Minhaz Kazi
Minhaz Kazi

Reputation: 3168

The other way to do it would be to unpivot your original data. Add a new color name indicator that will have the column names. And then have all the values in a single field. So your rows will increase by 3x amount and you will have 2 less columns. Then you can add the indicator field as a filter.

Upvotes: 0

Related Questions