CODEWITHSUNDEEP
looker-studio
nenadg
nenadg

Reputation: 430

Datastudio: Is it possible to use tables as data sources for ie. pie chart?

I have few tables filtered differently to show different totals about landing pages. I would like to use that totals to draw pie chart based solely on totals. Is that possible in Google Datastudio, or am I using it wrong?

Upvotes: 0

Views: 837

Answers (1)

Bobbylank
Bobbylank

Reputation: 1946

Thanks for the clarification. I think it might be possible using a calculated metric to create a new dimension that reflects your filter conditions. For example:

CASE WHEN yourDimension = "Yourfiltercondition1" then "TotalFilter1"
ELSE WHEN yourDimension = "Yourfiltercondition2" then "TotalFilter2"
ELSE "TotalFilter3"
END

Obviously you may need to use different functions to reflect your filters (IN, REGEXP_MATCH(), etc) and if you have any table filters which contain the same values then you may struggle to get something that is exactly the same as your tables.

Upvotes: 1

Related Questions