1,842 questions
-2
votes
1
answer
76
views
How to count NULL values in Looker Studio when using a date range filter (using DS_START_DATE / DS_END_DATE parameters) [closed]
I’m working in Looker Studio (Google Data Studio) using a Google Sheet as my data source.
My dataset looks like this:
Each merchant can have multiple shipments (or none).
I have a date range control ...
- 27
1
vote
0
answers
66
views
Vega-lite json for a line chart + error bands combo
I've been working on a personal project to create an election tracker and then a published dashboard in google looker. I have a google sheet imported and a simple line chart working already but I can'...
- 13
0
votes
1
answer
260
views
How can I prevent score card from being affected by a control in Looker Studio? [duplicate]
I need to ensure that a score card will not end up being filter when data is selected using a control in Looker Studio. How do I do that?
I found a related post that refers to grouping a filter as a ...
- 1,268
0
votes
1
answer
47
views
Looker Studio: How to Filter text field ends with _a or _b?
New to Looker Studio! I've had beginner training, but looking for a way to Filter to Include data in a Text Field the ends with "_a" OR a "_b". 'Ends with' is not an option in the ...
0
votes
1
answer
228
views
Looker studio compact numeric axis labels with whole number format
So I've got a chart that shows sales over time. Y axis is labeled 200k, 400k, 600k etc. It literally says 600K not 600,000. When I mouse over it shows the specific value for that timepoint 352,013....
- 1,108
0
votes
0
answers
57
views
Looker PDT Aggregation Issue: Measure Not Summing Correctly
I have created a Persistent Derived Table (PDT) in Looker, and I have another view that joins with this PDT.
In my Explore, I have a measure in the PDT that checks if sales > 0, and if so, it ...
- 1,215
0
votes
0
answers
192
views
Dynamically Hide Tiles on Embedded Looker Dashboard in React
I am working with a React app and we are embedding a Looker Dashboard on an internal company website. The Client has requested that we do not use the Looker sdk because they do not want to have to ...
- 119
2
votes
0
answers
282
views
Use dropdown value as parameter for other Looker Studio visualizations
I have a BigQuery data source that contains a list of dates. I would like to populate a drop-down control with this list. By default, it uses a selection value of "Latest" and I've updated ...
- 5,277
0
votes
0
answers
95
views
Looker Studio: Looking for some way to filter the visual without filtering the data underneath
I have a google sheet of sales deals over time, deals are in various deal stages such as closed won, closed lost, closed terminated etc. Main date dimension is close date and metrics would be monthly ...
- 1
0
votes
1
answer
105
views
Display Sessions Metrics on specific dates using Calculated Field?
Hello I want to display the following data in my Looker Studio Report:
Channel
24-Jul
Organic
54,015
Direct
9,353
Referral
1,448
Other
187
Social
70
Paid
24
Grand total
65,097
My Data Source is from ...
- 35
0
votes
1
answer
162
views
How to merge two dates?
Problem Statement:
I have a single table in Google Sheets with two date fields: Sales Order Date and Dispatch Date.
I want to create a single line chart in Google Looker Studio that shows Sales Qty ...
0
votes
1
answer
88
views
How to Inverse Heatmap Column Colors in Looker Studio Chart Widget?
I need help inverting the color gradient for heatmap columns in a Chart widget:
Current: Higher values = darker colors
Desired: Lower values = darker colors
The heatmap functionality seems to ...
- 376
1
vote
0
answers
155
views
Looker Studio Community Connector- "Authorize" button not working
I am trying to create a looker studio Google ads connector and I am currently stuck.
Anytime I try to click on the "Authorize" button (please see attached) to initiate connection, it does ...
- 13
0
votes
1
answer
150
views
Editor can't edit the data source created by Google App Script
So we create our own connector for Looker Studio using Google App Script. Let say We create the connector using [email protected] in Google App Script.
we also use [email protected] as the owner of the ...
- 14k
0
votes
1
answer
511
views
How can I connect Google Looker Studio with AWS Redshift?
I am trying to connect Looker Studio with Amazon Redshift but keep getting this error
I had to make sure everything related to connection details was the same and also tried to connect with Basic and ...
- 762
1
vote
0
answers
54
views
Creating a community visualization is blocked by CORB
I'm attempting to create a community visualization in Looker Studio, but I'm encountering an issue where only a white box is displayed instead of my custom visualization. Upon investigating the ...
- 11
-2
votes
2
answers
369
views
User should see option to select only a single date rather than a range of date in Google Looker studio
In Google looker studio, I can add a date range control that is automatically applied to all the tables in the dashboard.
I can then select a single date, by selecting the same date in start and end ...
- 894
0
votes
1
answer
96
views
How to execute SQL UPDATE query form "Google looker studio" to the PostgreSQL?
Is it possible for Google Looker Studio to send SQL queries to change data in PostgreSQL DB?
Where to see examples?
- 61
1
vote
1
answer
331
views
Are there any methods to send trigger notifications via email from Looker Studio?
I’m working on a project using Looker Studio to create dashboards, and I want to implement a feature that automatically sends an email to people when certain numbers exceed a specified threshold.
I am ...
- 11
0
votes
1
answer
90
views
How to calculate new, retained, lost customers in a given time period in Looker Studio
Let's say I have order data with customer name, order dollar amount, order date.
I want to create a chart in looker studio that always looks at the rolling latest 24 weeks and I am trying to determine ...
- 9
0
votes
1
answer
90
views
Will renaming fields in looker studio break things?
I have several different data sources coming in to my Looker Studio dashboards. I am considering renaming some fields in Looker Studio in order to organize stuff and establish some naming conventions ...
- 515
0
votes
1
answer
443
views
Query a table with the table name as variable
I'm building some dashboards in Looker Studio that require 3 of the GA4 daily tables that get added each day from the sync between GA4 and BigQuery.
I want to query those specific tables, as we've ...
1
vote
2
answers
625
views
Looker Studio BigQuery Custom Query returns error Not found: Dataset -:- was not found in location US
I'm adding a new data source to a Looker Studio report; using the BigQuery connector and a Custom Query.
The following custom query on a BigQuery dataset returns a location error:
EXECUTE IMMEDIATE '...
- 23
0
votes
0
answers
61
views
Looker Studio connector caching names & descriptions for metric fields
What's the problem?
We're building a looker Studio connector. It uses BigQuery as the base, but then also uses the getSchema in order to add custom fields on top of this.
Our problem is with the ...
- 849
1
vote
0
answers
83
views
can I get the day duration from date range filter in calculated field in Looker Studio?
I want to create a new field called Total Sales/Day.
I have Total Sales metric already. but the problem is, I dont know how to access the number of days (duration) from date range filter in calculated ...
- 14k