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…
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: +------------------------------------------------------+ | …
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…
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?
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…
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.