Stack Overflow
Stack Overflow

Questions tagged [looker-studio]

1796 questions
5
votes
2 answers

Is there a way to declare a variable in a data studio custom query?

I've got an issue similiar to the one described here : Pruning BigQuery partitions with Data studio I want to declare a variable to run a custom query in data studio. For example : DECLARE usd_to_eur_rate FLOAT64; SET usd_to_eur_rate = 0.8; …
JCDB
  • 135
  • 8
5
votes
0 answers

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: (8239 - 1706) / 8239 * 100 (7802 - 8239) / 7802…
Jonas Palačionis
  • 4,591
  • 4
  • 22
  • 55
5
votes
1 answer

Data Studio Filter results to rows whose arrays contain two values

I have a table like this: Name Array Dog [Barks, Furry] Cat [Purrs, Furry, Other] Broken Duck [Purrs, Feather] When I use a control and select Purrs and Furry, I get all three rows. The desired outcome is to only get the cat…
Jason Nichols
  • 3,739
  • 3
  • 29
  • 49
5
votes
2 answers

Google Data Studio - Use of User Defined Functions (UDFs)

Basic Question: Does Google Data Studio allow calling a SQL User Defined Function (UDF) within a Custom Query data source? My UDF works great in BigQuery. The exact same code (SQL call to a UDF) fails when creating a report to leverage this data…
Vector7
  • 107
  • 1
  • 7
5
votes
2 answers

Google Data Studio displays "null" – how to set the field value?

I am new to Google Data Studio. I think I have an issue, with turning dimensions into metrics or with correct assignement of values. This is because a colulmn which should display numbers just displays the string „null“. This is how it should look.…
S.H
  • 671
  • 2
  • 6
  • 22
5
votes
2 answers

How to substract a day to a date field in Datastudio

I need to subtract a day from a date field in Datastudio. My date has the DDMMYYYY format.
Dani Gonzalez
  • 93
  • 1
  • 7
5
votes
2 answers

Is there any API to get data from database into Google Data Studio through rest API only

Want to get the data from spectrum hub and use that same for report generation but, unable to get request data studio link for get method to pass it in postman with their respective parameters
prajakta
  • 59
  • 1
  • 1
  • 2
5
votes
2 answers

How to fix the display "Not Accelerated by BigQuery BI Engine" on DataStudio Report using BigQuery

I am using a Scorecard in Google Data Studio, and I keep having this warning (Thunder) ⚠️ sign saying - "Not Accelerated by BigQuery BI Engine". Is this an error, and how do you fix it?
Sadeeq Akintola
  • 227
  • 3
  • 7
5
votes
1 answer

How to filter BigQuery arrays with DataStudio

I have a dataset with two columns in BigQuery: 1. url 2. tags URL is a single value, and TAGS is an array(example below): row | URL    | TAGS 1      | x.com | donkey                      | kong                      | lives                     …
Machine Learning
  • 485
  • 6
  • 15
5
votes
2 answers

Filter record based on most recent record for Each ID in Google Data Studio

I have data with ID and Date. I want to fetch and aggregate data in given date range, but just the most recent record for any particular ID. Refer to following example: +------+------------+-----+ | ID | Date | KPI…
Rahee Hardaha
  • 51
  • 1
  • 2
5
votes
2 answers

Controlling and monitoring use of BI Engine Reservations

With the new beta BI Engine Reservations, I've noticed some queries speed up, but others remain unaffected. Will it be possible - to monitor how the reservation is being used? - to have some control over how the reservation is used?
Ian Rubenstein
  • 101
  • 5
5
votes
1 answer

How do I combine two date fields in Google Data Studio?

I seek to create a field in Google Data Studio using a CASE statement including a date column and a datetime column. Whenever the date column Start_Time is NULL, the datetime column Given_Timestamp is not NULL. The issue Whenever Start_Time is not…
Michelle Turner
  • 314
  • 5
  • 22
5
votes
2 answers

How can I auto refresh Google Sheets data source in Google Data Studio?

I created a project in Data Studio connected to Google Sheets in Google Drive. I need to update the data on the sheet periodically. I import the data from another Excel sheet but after doing this, I have to update the connection of the data sources…
Elias Tabarez
  • 71
  • 1
  • 4
5
votes
0 answers

Google Data Studio: Chart Calculated Field Invalid Formula

I'm building a report in GDS and I'm trying to take advantage of the new Chart Calculate Field. I have the following data unique_users 120,449 clicks 4,405 I want to calculate the CTR using this formula: SUM(clicks) /…
Asaf Nevo
  • 11,338
  • 23
  • 79
  • 154
5
votes
1 answer

Firestore Google Data Studio

I'm trying to connect firestore with data studio, use is connector made by the community but does not work. This is the error message Sign in with Google temporarily disabled for this app This app has not been verified yet by Google in order to use…
Oscar Mera
  • 64
  • 1
  • 7
1 2 3
…
99 100