New incremental feature
Hi allI wanted to share my thoughts on the new "incremental refresh" feature.It's actually a great thing.Unfor...
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
Automatically Refresh View when a Column is Added in GBQ Data Source Table
I've created views from underlying GBQ tables. I'd like to dynamically update the views every time a new colum...
how do i show dimension descriptions with codes
Hi all,I’m a newbie with LookML, and this are basic questions about lookup values. I am someone who learns bes...
Grouping Dimensions by Rank
Basically I have a dimension that has many values and I want to make a pie chart that includes the top 5, 10, ...
WITH...AS clauses break with non-persistent derived table assets
When a PDT is built with a “WITH…AS” clause at the start of the SQL definition, any non-persistent derived tab...
Blach borders for Tile
Can we put black borders for each and every Tile?
Join with different database and cloud
Hi!How can I join a table in Bigquery with a table in Redshift? I did it using merge in a look, but there is a...
Can Looker solve my Hogwarts example?
This is somewhat a duplicate of my other question, but I think it’s a better way to articulate it. If I get an...
How can I replicate a Sum with an Over clause?
I have some raw wishlist data in a simple form (timestamp, user_id, item_id, added) where the final item there...
Save color in parameter for reuse
Is there a possibility in Looker to save colors or other stuff in a parameter or variable, to easily reuse it....
Add timezone conversion when using custom fields
Sometimes I use Custom Dimensions to split my data by a point in time. Like let’s say 15th of February 2020. I...
LookML Model Diagrams (open beta)
Hey Friends! If you have not already heard I wanted to mention our open beta for LookML Model Diagrams. Some o...
Adding color to labels (view or group or label)
Is there any way we could color to labels (view or group or label)?
Will changing the font color or size of the multiple value custom visualization be available?
When working with multiple value custom visualizations from Looker, some functionalities of the HTML parameter...
Sync series in Period over Period on different column
I am trying to create a look that will compare the number of orders of the current month with the previous mon...
Drilldown on derived dimension
I am using Standard BQ SQL and trying to create a hierarchy on a dimension dimension: category { type: string ...
Dimension, return the latest date
Hello Looker community, I am trying to write a dimension (last meeting date) that will return the latest date ...
View fetch data from an external API
Hi all,I have a simple question, is it possible for a view or look to do an external API call and with the res...
how to create global filter that filter on greater then (>) and not on equal to (=) ?
I want to use global filter in my dashboard in a different way I want to show in the filter options the availa...
Creating Another Dimension Value Dependent on Other Values of the Same Dimension
Hey all,I’m trying to create another value of a dimension that would involve a calculation among other values ...
Connecting multiple strings as a new measure
Hello! I am wondering how to combine two strings (two different columns) into one new columnI am trying to com...
Is numeric comparison of parameter value in liquid syntax possible?
I have a parameter where the user would enter a number of days. I would like to be able to set some logic base...
Q1
A LookML developer adds an access_filter parameter to an Explore. When using the Explore, the developer notice...
Looker Maintenance Exam 2021
Let me know if anyone has completed the Looker Maintenance Exam 2021. Please share your views so it will help
Pulling measure values from views inside union block
I have a use case where we have a union view. This view joins 3 views with UNION join and with WHERE condition...
Illegal circular project dependency
Hey, Looking for suggestions on how to best architecture our models, using remote_dependencies. We want to be ...
LookML Parser/Validation Order with Liquid Variables
Hi there,I have base view with a dimension that need different joined fields according to the explore.I want t...
Dynamic Measure with input selected by user
Instead of creating multiple measures for a bunch of variables, I’d like to be able to create one with a dynam...
LookML Validator Misses Case Statement Errors
dimension: example { type: string sql: CASE WHEN ${order_amount} > 100 THEN 'Large' WHEN ${order_amount} > 50 ...
Extract substring based on delimiter
HiI want to create three new columns from an existing dimension(called category) which has upto 3 keywords in ...
