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 ...
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 ...
- 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. ...
- 21
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')...
- 13.2k
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.
- 1,206
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 ...
- 21
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-...
- 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 ...
- 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 ...
- 26
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 ...
- 121
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 ...
- 1,206
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.
- 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 ...
- 750
Only top scored, non community-wiki answers of a minimum length are eligible