Questions tagged [google-data-studio]
For questions about interacting with Google Data Studio. Questions about how to do data analysis are off-topic.
28
questions
0
votes
0answers
10 views
How to return/limit only X results in Google Data Studio?
I have one general query and then many tables/charts running on it.
In some of them I want to show only X results, how can I do that?
You know, like MySQL's LIMIT X (e.g. SELECT * FROM Table LIMIT ...
1
vote
1answer
11 views
Google Data Studio - Calculting Two Same name Fields in Two Different Data Sources
I am using Data Studio to do a Report on two Data Sources: Income and Expenses. These data sources have the same field names and each one of them has a scorecard to sum each of their values in the ...
0
votes
0answers
6 views
Convert table to chart and vice versa in Google Data Studio
If you create a table in Google Data Studio, can you convert it to a chart and vice versa?
0
votes
1answer
20 views
How to create a row level calculated field in Google Data Studio?
If my table looks like:
Date Conversions Clicks
2020-02-10 2 20
2020-02-09 50 80
And I'd like to add a calculated field of Ratio (conversions/clicks), which ...
0
votes
1answer
10 views
How to filter a data range dynamically by default in Google Data Studio?
I have a table with a date column. There are 2 alternative dynamic filters I'd like to have by default in the table I prepared inside Google Data Studio:
Show only data from the latest date in the ...
0
votes
0answers
8 views
Can Google Data Studio have a more interactive menu of pages?
Google Data Studio can have pages whereas each page can have multiple tables and charts.
Once done, there is a top corner option to move back and forth between pages. If you click somewhere between &...
0
votes
1answer
9 views
How to make the width fit to text in Google Data Studio?
While preparing a regular table, all the text (header and body) gets cut off.
Is there a way to have the width auto fit to text?
There is an option of Wrap Text, but that's not what I want.
0
votes
0answers
12 views
How Do You Plot Two Of The Same Fields (One Filtered, One Not) In Google Data Studio
I'm trying to create a line graph of time series data for website users from Google Analytics in datastudio where I have two plots, one of all users and one of users filtered showing only organic from ...
0
votes
0answers
10 views
Selecting max value of a metric per given dimension in Google Data Studio
I am trying to compare the maximum value of a metric with a selected value of a metric.
Consider this my data:
Name Metric_1
John 50%
Dave 60%
Tom 55%
I am trying to create a ...
0
votes
0answers
26 views
How do you use a lookup table in Google Data Studio?
So blended data in Google Data Studio is not a lookup table. Here is what I'm trying to do.
Say I have data set A that has sales data like this:
Name | Product | Price
Mary | ...
0
votes
0answers
6 views
Having trouble blending data in data studio
I'm using a blended data set with GA360 data from a currently active website and a now defunct website, and I wanted to show YOY comparison statistics in a score card. Basically, I wanted to show how ...
0
votes
1answer
20 views
Average monthly pageviews from Google Analytics in Google Data Studio
I'm using a Google Analytics property as a data source in Google Data Studio.
I have a table where each row is a section of the site (The table dimension is "Page path level 1").
I'd like each row ...
0
votes
0answers
6 views
Blended Data is not showing any values when there is data in Google Sheet
I'm trying to show the sum of data from a column in a Google Sheet. The scorecard that I am using is attached to blended data, as I need to be able to do a calculation with some other fields, but ...
0
votes
0answers
30 views
Google Analytics/Data studio- Counting number of campaign per users
I'm trying to bucket users by how many distinct email campaigns they receive. I want to be able to visualize similar to how "Count of Sessions" works. I can get count distinct of campaign as a metric ...
0
votes
1answer
278 views
Google Data Studio - Sum of 2 fields from different data sources
I'm just getting started with Google Data Studio. I have connected 2 different Shopify stores to it, which worked totally fine.
Now I try to show the sum of the revenue of both stores, but the ...
0
votes
0answers
814 views
How do I remove a “null” column or legend in Google Data Studio?
I have a simple Google Sheet for my source for Google Data Studio charts. Legends in pie charts and columns in bar charts show a "null" that I can't explain. My columns display correctly but there's ...
4
votes
0answers
173 views
Google Data Studio and Slack integration
How Can I connect my Google Data Studio reports, or parts of them with slack?
I would like that each day appear in slack some report that I will customize in Google Data Studio.
And if I want to do ...
1
vote
0answers
52 views
Google Data Studio Multiple Date Range
I'm a Data Studio newby so pardon me if my question seems stupid, I've a very simple dataset to report (see a record sample below):
CheckIn CheckOut Rate
2017-01-01 2017-01-10 ...
1
vote
1answer
46 views
Can I create a custom ratio based on two fields in Google Data Studio?
I'm trying to create a custom ratio in Google Data Studio that is:
'sessions with a particular event' / 'all sessions'
Can anyone tell me if this is possible?
I tried using a calculated field, but ...
0
votes
0answers
69 views
Google Sheets' REGEX to group values
I need to take into account text across multiple cells using REGEXes to identify larger grouping in another cell.
For example, using both a Source and Medium value to determine one larger Channel ...
0
votes
0answers
166 views
How to connect with two tables in google data studio my sql database
I am not able to connect with more than one table at a time.
How to connect multiple tables and how to create a report for the table?
1
vote
0answers
188 views
Google Analytics and Google Data Studio show a different 'Users' metric
There's a discrepancy between Google Analytics and Google Data Studio data. The metric "Users" displayed in Google Analytics is different from the one shown in Google Data Studio when I query the ...
0
votes
0answers
20 views
Not able to connect to Google Data studio
I am not able to connect https://datastudio.google.com/ from past 1 hour.I am able to access other website so internet is working fine..Is there any issue with Google Data studio
Google Data studio ...
1
vote
0answers
2k views
Google Data Studio - Comparison by previous month
I have this simple data:
Date Total Revenue
1/1/2017 $22,219.00
2/1/2017 $22,119.00
3/1/2017 $22,360.00
4/1/2017 $22,097.00
5/1/2017 $22,320.00
6/1/2017 $22,126.00
7/1/2017 $...
0
votes
1answer
512 views
Google Data Studio Date Range Filter -Report Level
I am creating multiple reports in Google Data Studio, I want to persist my date range selection for all reports. I have made date range control as 'Report Level' If I am creating multiple pages on ...
2
votes
1answer
717 views
Insert Text from Spreadsheets to Data Studio?
Is there a way/workaround to display a text value (not numeric) from Google Spreadsheets in Data Studio Report?
I found a way to display numeric values in Data Studio, but I couldn't replicate the ...
2
votes
0answers
672 views
How to evaluate a boolean in Google Data Studio using CASE
I am importing data from a spreadsheet with contains many columns, two of which are Address (which returns the URL of the page) and Canonical Link Element 1 (which returns the canonical URL).
I wish ...
5
votes
2answers
11k views
In Google Data Studio, how can I join 2 tables to be available in a report?
When I'm building a report in Google Data Studio from a MySQL source, I appear to only ever be able to work with 1 table per data source:
If I attempt to edit or change the datasource, I'm simply ...
