Grouping rows
Hello,I’m reaching out for some help on how to aggregate rows in order to correctly display them in a chart. I...
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 or select across several columns
Hi! I have a table with three columns. I want to be able to count all the unique values across the 3 columns. ...
Hotkey / Shortcut to Validate LookML
Anyone know of any way to Validate LookML without taking your hands off the keyboard?For me it would really im...
Creating several measures with same LookML code
Hello Folks,I wanted to create several measures (over 10) and the only difference between them is only one num...
PDT Regenerator Using Multiple Models
I have a model with 2 `.model.lkml` files, which use 2 different connections and share views.I have a function...
LookML Filter Field does not filter null values
In my looker instance, there is a filter only field defined in the LookML (called “feedback_selection_filter”)...
Average LAST 4 weeks by day
Attempting to create an average of a MONDAY over 4 weeks So AMOUNT 1, AMOUNT 2, AMOUNT 3, AMOUNT 4, FOR DAY / ...
Sum of duplicated rows
How can we calculate the total of a table where there are different granular level of the table?I have a table...
Custom filter on measure
I have created a parameter using allowed values and a certain range of percentages to select: parameter: param...
I'm trying to convert the data to lat long coordinates in the looker, but I can only draw the polygon by circular points.
I would like the drawing to be in polygon format, but it is coming as circles, if i join the dots, the polygon...
Custom Dimension with Sub Totals
So I have create 2 Custom Dimension to group our people with their designated Team and Managers.First Dimensio...
Creating a custom dimension cohorting users
Please help. For context, 1 user can have multiple generations of a product. Generation 1Generation 2Generatio...
Grouping dimensions using 'case when' grouping users lookml code.
Please help. For context, 1 user can have multiple generations of a product. Generation 1Generation 2Generatio...
Entering Developer Mode = Blank Look ML
Hi, I have a Looker dashboard that is working that I need to edit. When I go into Developer Mode, and then go ...
Drilling into count-distinct measure - Need to get only one row retrieved for each id
I have a situation where I need to drill into a distinct-count measure of ids. But the drill retrieves all row...
Dashboard Run/Stop button unresponsive when model has data
Howdy,Bit of an odd one. I run a bunch of dashboards in Looker and I’ve never seen this problem before. Can’t ...
How do I return a null value for a negative number in my statement below
if(is_null(${orders.need_by_date}),diff_days(${orders.created_date},${receipts.receipt_created_date}),diff_day...
How to filter for two weeks ago
I have a column that shows sales and I have a column that shows sales date. I am trying to create a filter tha...
[Analytic Block] - Pivot by Top X - Introducing bind_all_filters: yes
Pivot by Top 10 You’ve got a high cardinality dimension and you’d love to just see the Top 10 based on some me...
cancel group by in measure
Can i cancel group by for measure instead of whole explore?
Create 6 months rolling average table calculation
I want to create a 6 months rolling average on count_of_students table calculation by using quarter field.Can ...
PDTs that CREATE with daily incremental load
Hello! We know that PDTs are great at updating new data daily, but what if you are building a PDT from scratch...
Creating dimension by using another dimension from same view
Hi all,I’m trying to create new dimension that will have another dimension involved from the same view here is...
NULL label as parameter of field definition
Yes, we can always do COALESCE() in your field definition but I would like to leave the SQL as it is and those...
How i can get create a looker view from table stored in GCS bucket directly?
Hi Everyone,I need to access GCS bucket into looker but i couldn’t find any solution and i am aware of one sol...
How to make grouped column visualization out of simple select?
I want to do a column chart with multiple groups (just like the first one described on https://cloud.google.co...
Can I fill the latest non-null values to the filled missing dates?
An example:I have customer balances from the days they perform actions. For all the other other days, I would ...
Window Calculations (Partition by) gives different results depending on what (unrelated) fields are in the table
Hi, I’ve been trying to get sum certain values for other repeated values in the table using SUM(values_to_sum)...
Manifest Locking Error when "/" is in the branch name
I would like to use branches named release/*But when I refer it in `remote_dependency` field I get the error `...
BUG: Invalid syntax for dimension_group when creating view from table
This has been happening for at least a few months, but when creating a view from a table, the dimension_group ...
