Questions tagged [looker-studio]
1796 questions
0
votes
1 answer
Data Studio - How to get the average value within a given time frame?
I have my connector where I'm able to get the spend value within a given time frame (on the request passed to the getData it has the startDate and endDate parameters and the fields with spend, all normal). Now I want a card that shows the average…

Francisco Farias
- 31
- 1
- 4
0
votes
2 answers
Google Data Studio: How to enable authentication for API connector using 2 KEYS
I am trying to write a connector in GDS for a web service API. The API authentication method uses 2 KEYS (passed in the header): X-App-Key and X-User-Key
A 2-key auth flow doesn't fit into the 5 authentication options available in my .gs connector…

Kinglish
- 23,358
- 3
- 22
- 43
0
votes
1 answer
Print an iframe with Google Datastudio from a parent html
I have a Data studio dashboard embeded and I want to add a function to print the dashboard but it seems that for the CORS restrictions it is not possible to do this
is any work around this ?
I found this but it doesn't seem to work
print a pdf via…

jfk83
- 740
- 3
- 15
- 30
0
votes
2 answers
How can I extract the last path of an URL in Google Data Studio custom fields?
I'm using REGEXP_EXTRACT to get the last path of the Page Dimension in Google Data Studio. The Page URL has one identifier which is the same on all possible URLs:
+------------------------------------------------------+
| …

elitebook0711
- 13
- 1
- 5
0
votes
1 answer
How to fill in missing days of data with average of day before and after
I got Amazon Stock data from Yahoo finances, but there are some missing days that have no data.
I was wondering if there was a way, using google collab, to then "create" those missing days and fill them in with the average of whatever the adjacent…

UserX
- 105
- 1
- 10
0
votes
2 answers
How can I make Google BigQuery understand a date format like 04.01.2019 07:06:48.607?
I am using Google BigQuery to analyze a CSV-file in my Cloud Storage of 130 MB and 21 Mio. search strings entered of a webshop. When trying to evaluate this data with Google Data Studio I get no data when adding a "time dimension" with the format…

Nes Elm
- 87
- 1
- 3
- 12
0
votes
1 answer
About the way of saving BigQuery data capacity.(BigQuery/Data Portal/Data Studio/Google)
I want to know about the way of saving BigQuery data capacity with changing setting of Data Portal(Google BI tool/old name:Data Studio).
The reason is I can't execute SQL or defray the much cost , if I don't save my BigQuery data capacity .
I want…

asmrt
- 11
- 3
0
votes
2 answers
Soundcloud connector to Google Data Studio
I would like to display the statistics of Soundcloud more clearly. An import to Google Data Studio would be very helpful. Is this possible?

Nino Ophoven
- 1
- 1
0
votes
1 answer
Google Data Studio Calculatet Fields
is it possible to calculate like:
www.example.com + site
I want to add the Domain to the path, so that i can put a link of a specific page in the report.
Or is there a other way to show the Link of a site which should be reported?
THX

Tom tom
- 329
- 3
- 19
0
votes
1 answer
Quicksight - How to use log() in a calculated field?
I'm trying to move my BI dashboards from Google Data Studio to Quicksight.
In Data Studio, I use a log() function in a calculated fields. My formula is "20 * LOG(SUM(event_count))".
How could I do that same calculation on the go with QuickSight…

David Martins
- 63
- 1
- 4
0
votes
1 answer
Problems publishing a DataStudio report in a wordpress Personal Plan website
I have a Personal Plan on wordpress.com. I try to insert a DataStudio report in my web page, with the code shown below.
0
votes
1 answer
Is it possible to share filters between reports in Google Data Studio?
Google's Data Studio documentation makes some vague references to filtering functionality which does not appear to exist in the actual product. They say "Once you've added a filter to a report, you can use it in other components or even other…

Typel
- 1,109
- 1
- 11
- 34
0
votes
1 answer
Is There a Way to Automate the Creation of Data Studio Reports with Different Data Sources
So I am working on client reporting for my agency and Data Studio seems to check all the boxes we need.
However, we have several clients and I need a way to automate the creation of Data Studio reports.
The general steps I would want the script to…

przucidlo
- 63
- 5
0
votes
1 answer
How do I query a specific range of Firebase's analytics table using Data Studio's date parameters?
I've been reading up on how to query a wildcard table in BigQuery, but Data Studio doesn't seem to recognize the _TABLE_SUFFIX keyword.
Google Data Studio on using parameters
Google BigQuery docs on querying wildcard tables
I'm trying to use the…

marijnwillemse
- 3
- 3
0
votes
1 answer
Is there a way to find out how much data does a google data studio dashboard consume from BigQuery?
I would like to know how much data does Data Studio consume from querying a View from BigQuery.
For example, if I have a dashboard that is getting its data from a View in BigQuery, how much data would it be using?
I have tried to look at the usage…

Fauz
- 89
- 1
- 8