6 votes
Accepted

In Google Data Studio, how can I join 2 tables to be available in a report?

According to the docs as of this posting: A Data Studio data source can connect to a single MySQL database table. You can use multiple data sources (read: tables) in the same report, but you can't ...
Charlie Schliesser's user avatar
4 votes

In Google Data Studio, how can I join 2 tables to be available in a report?

You can actually add a joined tables to Google Data Studio - but it requires an extra step. In your mysql database, you must first create a view of the joined tables. Here is a link that explains ...
MuXx's user avatar
  • 41
2 votes

Google Data Studio and Slack integration

OK, so not the best way, but you can schedule an emailed data studio report which sends to a slack channel's email address. You'll need to 'click to expand' and view the PDF in the body of the email. ...
user263690's user avatar
2 votes
Accepted

How to parse RFC3339 with TZ to field so that Google Sheets recognizes it as valid datetime stamp

You can convert an ISO8601 timestamp into a JavaScript Date object and write the date into a spreadsheet cell like this: const ss = SpreadsheetApp.getActive(); const cell = ss.getRange('Sheet1!A2')...
doubleunary's user avatar
  • 14.5k
2 votes
Accepted

How to make the width fit to text in Google Data Studio?

Turns out if you stretch the table's overall width wide enough, then right click it, then the Fit to Width option doesn't cut off titles.
LWC's user avatar
  • 1,228
2 votes

How do you use a lookup table in Google Data Studio?

I have built a demo of this, so unless you are missing data (for which you could create a field based on category, setting it as "uncategorised" or similar if empty) then I'm confident you ...
Jack Bremer's user avatar
1 vote
Accepted

Map areas too low quality in Google Looker Studio

I figured this out myself. The Geo map has a limit of 1 million vertices: https://support.google.com/looker-studio/answer/9713352?hl=en#geo-limits&zippy=%2Cin-this-article%2Cconfigure-a-filled-...
MSC's user avatar
  • 131
1 vote

Google Data Studio - Sum of 2 fields from different data sources

I was also wanting to add the same data element, Total Unique Searches, for different sources and here is how I solved it: Click on Resource at the top and then select Manage Blended Data Edit your ...
Letitia's user avatar
  • 11
1 vote
Accepted

Set custom rolling date range for Google Data Studio

The answer is yes, there is a workaround through a Google Sheet and a blend in Google Data Studio. Make a copy of this spreadsheet, and edit the Start Date and End Date formulas according to your ...
Andreea Popa's user avatar
1 vote
Accepted

Google Data Studio - Calculting Two Same name Fields in Two Different Data Sources

I found the solution to this thanks to a user on the Data Studio Community Forums. I will summarize for those looking for a similar answer. As of writing this, Data Studio has no way to refer to a ...
Russ Wilkie's user avatar
1 vote
Accepted

How to filter a data range dynamically by default in Google Data Studio?

Turns out the second approach can be done by adding a Date Range Dimension, which then allows to change the Default date range: I don't think there's anything in the UI to achieve the first approach ...
LWC's user avatar
  • 1,228
1 vote

Can I create a custom ratio based on two fields in Google Data Studio?

Rather than "sessions with a particular event", use total events / all sessions, and then create a filter to restrict it to the particular event you are interested in.
Bronwyn V's user avatar
  • 149
1 vote

Google Data Studio Date Range Filter -Report Level

You partly answer your question. The feature is for "Report Level" in the same report. At the moment, you can have multiple pages follow the report level rule in the same report, but there is no ...
Julio's user avatar
  • 770

Only top scored, non community-wiki answers of a minimum length are eligible