235 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
223
views
Looker Studio: Is URL parameter-based automatic filtering technically impossible when using Google Sheets as a data source?
URL Parameter Filtering with Google Sheets Data Source
Background
I'm using Looker Studio with Google Sheets as a data source and want to display reports with specific filters applied directly via URL ...
-1
votes
1
answer
93
views
"Invalid cast from BOOL to TIMESTAMP" error in LookML/BigQuery
I am trying to use Templated Filters logic in LookML to filter a look/dashboard based on flexible dates i.e., whatever date value the user enters in the date filter (transaction_date_filter dimension ...
0
votes
1
answer
194
views
How can I create a Looker Studio dash by just writing SQL queries?
I'm used to building data viz in Redash or Grafana, which both have the workflow:
New Dash → New Chart → write some SQL / choose visualization options for the output → Done
For a new work project, I ...
0
votes
0
answers
42
views
In Looker BI, is there a way to turn off cell visualisation upon when drilling down?
Initially, to achieve this, I added html: {{rendered value}} to the measure as such:
measure: net_sales {
type: number
sql: COALESCE(${net_sales_raw}, 0) ;;
drill_fields: [sales_detail*]
...
0
votes
1
answer
152
views
How to format just the total row in a Looker BI table
I'm trying to format the "Totals" row (row that sums up all the values in each column) of a table to be BOLD, but I'm not too sure how to do it.
I've looked around the "edit" menu ...
1
vote
1
answer
183
views
How to do MFA with Looker and Snowflake
By now, Looker connects to Snowflake using credentials.
Snowflake is demanding applications use MFA by 2026.
How do we accomplish this with Looker?
0
votes
0
answers
58
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 ...
0
votes
0
answers
80
views
Looker dashboard or (visual of dashboard) broken alert using looker 4.0 API
In our company we have developed around 100+ dashboards where each dashboard has one or more visuals/graphs. I want to create an alert system using looker api (4.0) so that whenever dashboard or a ...
0
votes
1
answer
109
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 ...
0
votes
0
answers
25
views
Hide current months table calculations
I have a looker look that shows pivoted monthly data and I have an extra table calculation column that shows the difference in cost between one month and the following month. Obviously the current ...
0
votes
0
answers
315
views
Customized tooltip in Looker
I created a histogram on Looker with Stacked Percentage values. I need to create a tooltip that allows me to see all the values represented in it according to the following format:
Tooltip Title:
...
0
votes
0
answers
238
views
Looker API 4.0 filter expressions
I'm building an aggrid based on looker data and using the API v4.0. I've successfully gotten serverside sorting working but filtering is causing me issues. For the project, I am using Looker Open-...
0
votes
0
answers
109
views
How to Use a Dimension for Filtering While Avoiding SQL Execution in Looker?
I’m working on a Looker project with two main datasets:
Table A: Contains only id values and other related data.
Table B: Maps id values to human-readable name values (e.g., id-name).
My goal is to ...
1
vote
1
answer
353
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 ...
0
votes
1
answer
787
views
How do I add the current Week number in Looker Studio on screen
I think what I probably need is a calculated field with something like this in the formula:
WEEK(CURRENT_DATE())
But I can't figure out how to include that in somekind of Scorecard or some other ...