Questions tagged [google-data-studio]

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

Filter by
Sorted by
Tagged with
1 vote
0 answers
69 views

Google Data Studio Scrolling up and down is not working in the present mode

I have used Google Data Studio for years now, and lately, I've noticed that when am presenting with the Actual Width option, I can't scroll down to see the rest of the page. I have a lot of reports ...
Sarah's user avatar
  • 35
2 votes
0 answers
88 views

YoY in Google Looker Studio?

I connected Google Looker Studio a.k.a. Data Studio to a database with sales data from 5 years ago until now. When I plot the data onto a stacked bar chart, the current year lags behind because we're ...
ᴍᴇʜᴏᴠ's user avatar
2 votes
1 answer
102 views

Map areas too low quality in Google Looker Studio

Why are the local government area (LGA) shapes displayed in Google Looker Studio's Geo chart (using Filled areas) so low quality / fidelity, even when zoomed in? Basically each area has insufficient ...
MSC's user avatar
  • 131
0 votes
0 answers
761 views

How to sort pivot columns in Looker Studio in Viewer mode?

If it's a table, all one has to do is click the column's title or right click and choose Sort By: [ How can the same be achieved to pivot tables?
LWC's user avatar
  • 1,268
3 votes
1 answer
891 views

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

I have a Google Apps Script which receives a date/time value formatted in rfc3339, with Timezone info, for example: 2022-12-29T06:34:07.442788Z However, Google Sheets doesn't recognize this as a date (...
Stacks's user avatar
  • 33
0 votes
1 answer
217 views

Is it possible to link a cell inside of the IMPORTRANGE formula in Google Sheets?

Scenario: I have a master Google Sheets spreadsheet with dozens of pages linking to Data Studio. Each page has an IMPORTRANGE formula linking to other Google Sheets spreadsheets. These other ...
Jamie's user avatar
  • 1
1 vote
0 answers
15 views

How do I output text to an aggregated formula in google data studio?

I have a problem with the formula below in Google Data Studio. As you can see it did not perform correctly, it should return the boxed value as "TRUE". The problem I think is because of ...
Patrick Nino Buquiran's user avatar
0 votes
0 answers
8 views

Automated webpage performance metrics from multiple external data sources

We currently use google sheets to pull together performance of webpages across the multiple platforms they integrate with. It's a laborious, manual process. We have a long list of pages from our ...
Dan's user avatar
  • 113
1 vote
1 answer
86 views

How to make an entire page appear Landscape?

is it possible to make one or even just all pages appear Landscape instead of Portrait? I'm talking about pages, not reports, unlike most of Report and page layout (which casually mentions "You ...
LWC's user avatar
  • 1,268
0 votes
1 answer
542 views

Set custom rolling date range for Google Data Studio

Our company reports on data from the 21st of each month to the 20th of the next month. Is there a way I can set an Advanced date range filter in Data Studio to accomplish this? One that I don't have ...
Iwan Pieterse's user avatar
0 votes
1 answer
411 views

Problems merging 4 columns into 1 and charting them in Data Studio

I would need to unify the data from columns Metod_1,Metod_2,Metod_3,Metod_4 and Metod_5 into a single column, but keeping the resolution date data associated to each row: Having resolved the above ...
Ger D's user avatar
  • 3
2 votes
0 answers
152 views

Google data studio not showing comparison

I have 2 data sources - one is Google Analytics, the other one is a table from big query: I am simply trying to display the % change per day in both metrics, so for example in the first I would show: ...
Jonas Palačionis's user avatar
1 vote
0 answers
12 views

Google Data Studio - can I use Bubble Chart to show totals for fixed combinations of X and Y (not statistics but values)

So I have a list of items that have Impact and Urgency parameters. These parameters all have a value of 1, 2 or 3. I'd like to visualize a grid that shows the amount of items for each combination of ...
FDM's user avatar
  • 111
1 vote
0 answers
308 views

Average group by [closed]

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 | ...
Asaf Nevo's user avatar
  • 171
1 vote
1 answer
704 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 ...
Russ Wilkie's user avatar
0 votes
1 answer
2k 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 ...
LWC's user avatar
  • 1,268
0 votes
1 answer
2k 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 ...
LWC's user avatar
  • 1,268
2 votes
1 answer
3k 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.
LWC's user avatar
  • 1,268
1 vote
1 answer
4k 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 | ...
Justin's user avatar
  • 320
0 votes
1 answer
304 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 ...
jacobe's user avatar
  • 101
0 votes
2 answers
6k 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 ...
user avatar
1 vote
2 answers
23k 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 ...
Big Al Monroe's user avatar
5 votes
1 answer
3k 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 ...
Laura's user avatar
  • 151
1 vote
0 answers
258 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 ...
Andrea Fiorito's user avatar
1 vote
1 answer
119 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 ...
lachyw's user avatar
  • 11
1 vote
0 answers
315 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 ...
E. Faslo's user avatar
  • 111
3 votes
0 answers
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 $...
urvah shabbir's user avatar
0 votes
1 answer
621 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 ...
Mayank's user avatar
  • 101
2 votes
1 answer
2k 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 ...
iTurki's user avatar
  • 133
2 votes
0 answers
1k 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 ...
inkovic's user avatar
  • 121
6 votes
3 answers
19k 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 ...
Charlie Schliesser's user avatar