Flattening BigQuery tables to Analyze in Looker
Hi all, I am trying to bring the data from my company’s app in BigQuery into Looker so I can then create visua...
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
Define multiple independent conditionally_filter requirements on model?
I have multiple conditional filters that I would like to apply independently. From what I’ve read so far it ap...
Rename columns used in a Join
Hello! I would like to join to the same field with two different ids in a parent table and rename the columns ...
Trying to create a custom filter that selects User IDs from a separate query (embed a query into a custom filter)
I’m trying to create a custom filter that selects User IDs based on specific criteria. Essentially embedding a...
How to get the access for demo account for practice
Hi team, I am looking for a looker free trail account for practice . please help me how could I get that.
SQL Code to return the 'previous' entry if null
Hi ! I have a recruitment table that for a particular job maps job stages to milestones. The below is an examp...
User Custom Tiers with Parameters
A common way to analyse groups of data is to use the tiers parameter in LookML. This will group a dimension as...
Looker w/ Oracle 12c - Can I use views created in Oracle for modeling
Hello There, I am using Oracle 12.c with Looker. I was able to test the connection to my database, however in ...
conditional formatting of charts
Hi there, Is there a way to conditionally format bar charts and more based on the values of a calculated measu...
SQL Code being re-used
Hi, I am writing some sql code in Looker ML but when I am referencing to another dimension that also has an ex...
Creating new views
Hi Looker Community, Was wondering if anyone knows the answer to this. I am looking to build a report off a ne...
Error when I put two measures in an explore
Hello! I recently have had problems when I tried to put two measures in an explore and the result is the follo...
Resources exceeded during query execution in BigQuery with window function
Moderator note: Split from "Resources exceeded during query execution" when building derived table in BigQuery...
"Resources exceeded during query execution" when building derived table in BigQuery
In some cases you will get an “Resources exceeded during query execution” error when trying to build a large d...
Templated filter causing a - Syntax error: Unexpected '{' - in compiled SQL
I’m trying to use templated filtering in a View and it keeps throwing a syntax error when I try to use an Expl...
Capturing count of records for a date between two dates
Hello awesome people, I am stuck with this problem where I have records of hotel bookings, where I need to fin...
Fiscal month name
I have used fiscal_month_offset to create fiscal calendar for my client. For date timeframes I see options for...
Need the include statement in my view file, but the include statement prevents validation
Hi, I received this error: No such explore "ndt_pageview_v2u_explore", so in the view file I added include: "....
Hyperlink in SQL Runner Results
Hi! I’m just a beginner and forgive me if I use terms incorrectly. I know we can set hyperlinks in lookML, but...
New DuckDuckGo bang for searching Looker documentation: !lookdocs
Are you a DuckDuckGo search engine user? I added a Bang Shortcut for Looker documentation called !lookdocs. So...
Redshift -- Connection refused, whitelist issue
Getting the error: Connection refused. Check that the hostname and port are correct and that the postmaster is...
Function Error
Do you know why a function returns an error, but not all the time? I was working with “Floor”, I tested it and...
Measure Returns NULL When it Shouldn't
Using Snowflake connection. Given the following dimension_group and measure: dimension_group: Started { label:...
Alignment for Null values not working
For some reason, my alignment is not working for null values. It is very weird that all numerical values are a...
When does old PDT get deleted?
I am seeing the error “relation ‘looker_scratch_XXXXX’ does not exist” quite often. This usually resolves itse...
Deleted PDT's still getting refreshed
I saw a PDT taking almost an hour to rebuild. The frequency was daily. I removed the PDT view from my project....
How to partition by a derived column field
I wanted to create a derived table and in one of the columns, I want to partition based on another derived col...
LookML Best Practices
Looking for some of the best practices we follow when building in LookML? Here are some helpful tips: Naming C...
Not able to see the LookML dashboard front end in the folder in development mode as well
I am not able to see my Looker dashboard in development mode. I copied the LookML of the User Dashboard and pa...
