Questions tagged [google-data-studio]
For questions about interacting with Google Data Studio. Questions about how to do data analysis are off-topic.
29
questions
0
votes
0answers
8 views
Detect which addresses were not recognized on the DataStudio map
I have a list of addresses to be displayed on the map. Many of those addresses are detected by the Google Maps graph in DataStudio, but others are not. Is there any way to know which ones have not ...
0
votes
0answers
6 views
Google Data Studio - displaying a chart based on pivot table, without showing the pivot table?
My raw data is in Google Sheets, with one of the columns representing categories that should act as filter. As a tryout, we've created pivot tables in Sheets, and charts on those pivot tables.
Now I'...
0
votes
0answers
16 views
Problem with setting up filter with the date
I have data source from PGsql the data looks like 2019-05-08 08:57:54.173726
and when I connect with the data studio, the field automatically becomes:18 May 2019 with formatting Date(YYYYMMDD).
Now, ...
1
vote
0answers
12 views
Google Data Studio - Average group by
I have a table with the following columns:
Customer Id | Customer Name | Participants
customer #1 | C1 Name | 10
customer #2 | C2 Name | 20
customer #3 | C3 Name | 30
customer #1 | ...
0
votes
0answers
19 views
Error when blend custom views with date params
I just create a custom query in datastudio that use date params (to reduce costs) like this:
The result field works fine but when I use this view in blend functionality for graphics (bend alone, ...
0
votes
0answers
24 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
21 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
9 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
77 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
24 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
13 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
26 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
13 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
89 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
242 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
12 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
22 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 ...
-1
votes
0answers
8 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
1answer
734 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
1answer
2k 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
332 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
118 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
63 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 ...
1
vote
0answers
190 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 ...
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
542 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
899 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
785 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
13k 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 ...
