BigQuery Table Sampling: LookML Syntax Explanation
Table sampling is a feature that enables users to query random subsets of data from a large BigQuery tables, w...
Modeling
Building a healthy project - and keeping it that way. Share your stumpers and successes with data management, performance optimization, SQL, LookML, caching, and more.
Forum Posts
Looking for a solution to count unique working days in Looker with existing parameters
Hello Looker community,I'm working on a project where I need to count the unique working days based on data in...
Exploring Data with Looker: Challenge Lab
Please for Task 1 in Exploring Data with Looker: Challenge Lab, who has completed it? I am having issues with ...
how to create a date filter that filters different dates in the dashboard ?
Hi, i am seeking a solution to replace the date filter in Google data studio (Looker studio), i want my create...
Line chart of weekly accumulative unique values
Lets say I have a data table like belowid uuid date 1 1 2023/04/04 2 2 2023/04/05 3 1 2023/04/11 4 3 2023/04/1...
Switch between two measures defined in two different views
Hello,I would like to give the users of my dashboard the opportunity to switch between two different measures ...
Group By Average
Hi,I am attempting to acquire the average number of days an account is open for by business group.. There are ...
How i can to translate script LookML to SQL Bigquery ?
I wanted to know if I can translate a script in lookml to sql bigquery inside the looker.
SQL Error in CREATE TABLE as SELECT
Hi.I have received this error. All datasets under the project is located in the US except one dataset. Can thi...
How to attach a dynamic money value (Currency) to a amount measure
Hi,In the view we have a separate dimension called ‘doc_currency’ with multiple currencies such as USD, EUR, H...
How to filter multiples values on a custom measure filter?
Hi, everyone!I’m trying to create a custom filter on a custom measure that uses a string column to filter a bu...
Percentile ignoring duplicates
I have a dataset that has duplicates. It looks like this:Order Price 1 2 1 2 1 2 2 3 3 4 4 8 4 8 4 8 4 8 5 10 ...
Dynamic QoQ in Looker
How to do QOQ analysis in looker in dynamic approach, for example if the user selects 2023 q2 it should compar...
Can you use LIKE in a custom dimension?
I have a custom dimension that returns a “yes” or “no” based on an OR condition that operates on two different...
Is it possible to extend two views and use a LookML parameter in the extended view?
I have two views:country.view view: country { sql_table_name: my_project.my_dataset.country_table ;; dimension...
parameter for finding zoomlevel of map in looker
Is there a way to find the zoom level of the map through lookml code,my sql looks like this SELECT CASE WHEN m...
Table Calculations without row limit
Hello,I have a sales table by seller. I want to calculate percent of sold quantity by each seller. But when i ...
What exactly is a scratch schema?
I saw this term “scratch schema” when learning about PDTs. I guess it would mean database schema design or som...
How to display only a single column for a measure within the pivotted table?
Hi!I’ve been working on a looker explore (using LookML of course!), and I’m attempting to display only one ins...
Dependent Looker filter depending on user selection in dashboard filter
There is a dashboard filter with 4 user input selections. Based on what user selects there I want to be able t...
Show related table field as field and list second related table fields as list
Our data models look a bit like this:user: { id, email, name}segment_type: {id, name}segment: {id, segment_typ...
Dimension Custom Sort
Is there any way to custom sort the Dimension in not alphabetical order besides of adding extra spaces in the ...
Problem in implementing Period over Period Analysis
Hello,I try to follow the metholodgy explained here to compare 2 “time” to hire from differents periods of tim...
Unsupported operator: OFFSET
Hello,I try to calculate the variation of a metric that change everyday, I would like to display the percentag...
JSON from Google Sheet as Data Source
I have a Google Sheet that’s filled from an API that I’m using as a Looker Studio Data Source. The problem is ...
How to get filter selected minimum date and max date, and display on a table
I have a table with multiple columns, one of which is "Created_date". We also have a filter applied on "Create...
Create a Tableau connector for Looker
Hello, I need use a Tableau dashboard with a data source for Looker Studio. How can i create a connector for t...
Calculating average across two views in looker when dealing with timestamp difference
I am working with a data where I need to calculate the difference and average of when a user is created and co...
Looker Incremental PDT creates and duplicate records
Hi, Recently I have implemented incremental PDT and after few weeks I realize its creating duplicate records i...
Filter Data To Only Show Values That Appear Once
Hi, I have data where “order numbers” can be repeated for multiple rows. I am trying to filter so that only ro...
