Questions tagged [google-data-studio]
For questions about interacting with Google Data Studio. Questions about how to do data analysis are off-topic.
31
questions
-1
votes
0
answers
2
views
GOOGLE DATA STUDIO COMPARISON STUDY DATA
GOOGLE DATA STUDIO COMPARISON STUDY DATA
*
hi, as you can see from the photo I created a chart to monitor the trend of the current account over time
*
I would like to create something that allows me ...
0
votes
0
answers
4
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 ...
0
votes
0
answers
7
views
Applying Filter on two variables in Google Data Studio
I would like to apply a filter on two fields on the same report:
I have a pageviews report and an Events Label Report on the same page. My overall pageview number is the sum of Events + Pageviews. ( ...
0
votes
1
answer
30
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 ...
0
votes
0
answers
9
views
How do I calculate percentage for my y axis based on a subset of data within the column?
I have a simple multiple choice app that logs answer submissions for different quizzes. In this example, there was one session that logged 3 answers (for 3 different questions) for the "LMBB&...
0
votes
0
answers
21
views
Add a number of Zeros to a data set and Calculate STDEV in Google Data Studio
I want to calculate Standard Deviation in Google Data Studio for a data set. Now, I have a data set that looks like this:
30€
35€
20€
10€ etc.
And I also have the number of users (in this case 100 for ...
0
votes
0
answers
25
views
Display Survicate survey results into a Data Studio dashboard (through Google Analytics events)
I'm trying to create a dashboard to display survey results.
The survey was powered by Survicate and linked to Google Analytics through events. This allows to get more data on survey respondents.
Then ...
0
votes
0
answers
135
views
Create a custom sort order for filters in Google Data Studio
I have a dashboard where I am filtering by month, but I have had to change the dates that fall within each month because of fiscal periods so they are stored as text. Because of this, my filter shows ...
0
votes
0
answers
32
views
Data Studio formula for one-to-many count
I have a large table of transaction data that I am trying to analyze. The table is formatted with a transaction having multiple rows depending on the number of items purchased (one row for each item).
...
0
votes
0
answers
9
views
Return a COUNT of goal completions this month *excluding today*
I'm trying to create a calculated field that adjusts our daily goal target for the remaining days in the month.
My logic is: ((overall daily target * # of days in the month) - goal completions *...
0
votes
0
answers
11
views
Google Analytics - Reporting a custom value
I have a vue website, using vue-gtag but a general answer can help and I will set the settings accordingly to vue-gtag.
I want to report how many items the user sees anytime he opens up a specific ...
1
vote
0
answers
80
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:
...
1
vote
0
answers
11
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 ...
1
vote
0
answers
86
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 | ...
1
vote
1
answer
330
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
1
answer
1k
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
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 ...
2
votes
1
answer
2k
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.
1
vote
1
answer
2k
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
1
answer
178
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
2
answers
4k
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
1
answer
15k
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 ...
5
votes
1
answer
1k
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
0
answers
236
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
1
answer
97
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
0
answers
264
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 ...
2
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 $...
0
votes
1
answer
593
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
1
answer
1k
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
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 ...
6
votes
3
answers
18k
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 ...