Datagroup Status: "Waiting for Trigger Checks". PDT's won't automatically rebuild
I set up a new Datagroup Trigger but the trigger check does not seem to be running. In my PDT Maintenance sche...
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
Custom HTML coloring for bar colors
I have html formatting for a number that color codes the number based on ranges of values. When I plot this to...
Custom drill down involving table calculations
HiI am attempting to create a custom view when drilling into a value in my dashboard, however, despite definin...
Create an "Other" bucket in a chart
April 2016 Update: You can also add an “Other” bucket [using Table Calculations] https://community.looker.com/...
Cannot view table calculations in custom viz
We have made a custom viz similar to the Single Value viz in looker. The Table Calculations are not visible in...
Implement the JOIN condition while using DRUID Database Connection in LOOKML
Hello Everyone,Is anyone having idea on how to join two views in LookML model while using the apache druid dat...
Go to LookML destination for extended dimension
Let’s say we have view A and view B. View B is an extension of view AFor reasons that probably aren’t worth th...
A quick flowchart beyond simple LookML
Hi,I have been dabbled around Looker for years and this community helps a lot.This time I try to make some con...
Getting Extended Views to work
I’m experimenting with extending views but haven’t been able to get the dimensions/measures from the extended ...
Feature Request - Add currency named formats with 4 decimals
I prefer to use value_format_name any day over writing custom formats that can be mistakenly typed diffferentl...
Looker Explorer/View/Measure union
Amit24 Kumar Aug 10, 2022, 6:40 AM PDT I have created two views A and B, that I want to combine into a new vie...
Incremental PDTs not incrementing when referencing the same derived table more than once.
I came across this problem a month ago. I have a SQL-based derived table (not a PDT), which I reference twice ...
Labels in line charts
Can anybody help in choosing the label values dynamically for a measure i.e I have a measure for current year ...
How often will the cache be cleared by this data group which using sql_trigger?
If I have a datagroup with a sql_trigger of ‘SELECT CURRENT_TIMESTAMP" (that is, it selects thecurrent date, h...
Constants Failing to Resolve in SQL Code Generation
We started experiencing this issue recently and I wanted to reach out to the community to see if anyone else i...
How to convert time ( 01:02:00) to 1 hr 2 mins in looker
Hi Have a date column with 02:01 :03 like this then how can I display it in user readable format.ex : 02:01 :0...
What do you know about golangtraining
Join HKR Trainings to get the best learning experience in Golang. During the course training you will explore ...
How can I dynamically change labels based off year?
In LookML I want the label to change based off of the year that is being explored. For example, the measure is...
Dashboard - Build a parameter that show value from a view or from another
Hi,I’m looking to build a dashboard showing the turnover of our firm. Usually people in our firm will query tu...
LookML IN Condition
I am troubleshooting an issue with a dashboard, and am trying to understand how Looker would interpret this li...
How do I get rid of branches I don't want
Nevermind friends I figured it out.
Extend with Liquid Parameters
Hello!I would like to build an explore (loans) that is almost exactly the same as another explore (orders) but...
Liquid: Checking in_query for a set of dimensions
Hey Everyone, Hope you are all fine and well! I know basic liquid in the realm of looker but now I have a more...
To_Date Function When Date Field is a Quarter
I am trying to find the dollar variance between two quarters. When I have my date field in months in a pivot, ...
user selected value in query as filter
I am trying to create a derived table based off the below query on Looker. Except, I want the user to choose t...
creating a measure to find # of users with X # of rows in a table at a time grain.
i’m looking to get the count of users with more than one ticket in a table that is at the ticket grain. So whe...
LookML error: The field "fieldnamehere" is of type "string" but is listening to a filter of type "field_filter" that specifies a field of type "(?)"
Hi, I am getting this warning when I validate in LookML. I have a filter for currency (filter name: Currency)....
How to convert string to timestamp in looker
Hi team,We have date string as 20210131120101(YYYYMMDDhhmmss) in table. We want to interpret this string into ...
Date Label Issue
Hi Community,I am new to looker. I have mapped in a new model and in the view there are a number of Date field...
Deployment strategy that involves not breaking existing content
Heya!Would love to know what deployment strategies are folk using in order to deploy graceful changes.To give ...
