Dimension Grouping Description
Given the following LookML: dimension: GroupField1 { group_label: "Group" group_item_label: "Field 1" label: "...
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
Dashboard Ignoring the filter value and showing all results
Our database is BigQuery and Built a dashboard using LookML. A field account number is passed with - where fil...
How to use the Dimensions with Max/Min aggregration
Hi I am trying to use the aggregation function in Dimension and it is giving error “is not a valid group by ex...
How can we define a dimension based on another dimension?
I get this error: The Amazon Redshift database encountered an error while running this query. ERROR: column “d...
Duration dimension_group: fractions?
Can the values of a duration dimension_group display fractions? For example, the underlying data is “90”. Dura...
Only use quote identifiers for Postgres connections, when necessary
Right now it seems like every column gets quoted in double quotes by default, which might lead to problems und...
[Analytic Block] Dynamic Previous Period Analysis using date_start, date_end
Looker has created this block to make analyzing data easier and more efficient. This Data Block is made availa...
Including rows outside of dimension filter for running total
I’m currently tasked with getting a cumulative running total of the number of users that log in to my companie...
reference User history view from one looker instance into another instance
I’m creating a multi-source model in one instance of Looker and need to access the User History view from a di...
setting Case statement on yesno dimension that will work in user_details drill down
I have a yesno dimension that I need to read as a string. ex. case when x = “no” then “send” when x = "yes the...
[Analytical Block] Yet another Period over Period modeling block (2 parameters + 2 dimensions only)
Hello Looker community! At Montreal Analytics, almost all our Looker projects were at some point in need of pe...
Date Processing
I am developing an Aging Balance Report where I need to retrieve the last date of the month for previous month...
Need help with design (UI) ajustments
Hi all. I’m a product designer and new to Looker, Currently working on adjusting the Looker implemented dashbo...
"All" Value filter
HI, I have Column called Product_status and values are (“Cancelled”, “Complete”, “Processing”, “Active”, “Inac...
Extends for Explores with multiple Joins
Hi there! I was looking for a way to merge two explores in my Looker Model. These two explores have multiple j...
Using Data Group from Model A to trigger PDTs in Model B
Hi, I have two models A and B in a Project. Model A: MySQL Database Connection It has a Data Group which is tr...
Alternative to a Right Join in LookML
I am tying to create a viz that displays inventory and sales data per sku for all of our products. As a simple...
Adding SQL Code via Filter to Nested Section
I apologize in advance if this is simple. I’m new to LookML and wasn’t able to find anything in the documentat...
SQL Trigger Value Triggering Regeneration in Models the View is not deployed in
Hello, We use BigQuery as our DWH and we have 2 models: 1 for Legacy SQL and 1 for Standard SQL and various vi...
Filtering data using two dates in LookML
Hey guys! I’m trying to get the count of leads between two dates. Below is the LookML I’m writing in order to ...
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...
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...
