Questions tagged [google-data-studio]

For questions about interacting with Google Data Studio. Questions about how to do data analysis are off-topic.

Filter by
Sorted by
Tagged with
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 ...