table calcs vs LookML
Hi community, Was hoping someone can help clarify one point for me. Let’s say I have the example below to char...
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
Distinct count in pivot
Here is a sample of data which shows applications and reasons for which applications are declined. Total 3 dis...
Why are Dimension_Groups sorted "the wrong way round" for date values?
I have a Dimension Group for my “Delivery Date”. dimension_group: date_from { group_label: "gl_dim_time_del_da...
Table Visualization for Daily Counts
Hello, I have a single table with multiple datetime columns that represent when a row in my table transitioned...
Merged Queries not showing expected results
Hi Team, I have a requirement to merge two views in looker and its not working as expected. I want to understa...
Using slugs instead of dashboard id in url's.
I have read in a couple places about using a dashboards slug instead of its id in a custom url. I have not bee...
BigQuery tables without Primary Keys
Primary keys are essential for Looker’s symmetric aggregates to work. Sometimes you end up with a table withou...
How to combine 2 views /explores
View A: used devices (no primary key, many records per day) experiment bucket device seconds x y z day Mandato...
Left join not operating correctly, appears to be working as an inner join
I have some finance data, some of which is actuals from the past until now (as a running total of small transa...
Best way to provide user guides / data dictionaries to clients
Any thoughts on what is the best way to embed userguides in dashboards. I come from the Tableau world where we...
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...
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...
| User | Likes Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
