Localization for custom column names
Hi All, I am trying to have my lookML dashboards support Spanish and English and for some of the columns I’ve ...
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
Make Measure Value Fixed Regardless of Dimension in the Visual
Hello Looker Community,I’m wondering if there’s a way to make the value of Measure changes due to the Dimensio...
Filters DO NOT always perform time zone conversion
When I created a NDT and specified bind_all_filters: yes, the filter from the explore did get passed through, ...
LookML Dynamic query in .model
Hi,I is there a way to toggle between two connections based on my user attributes eg: uat and production. eg i...
Calculating User Repurchase Rate
Definition: How frequently do your users, who have already purchased an item, purchase again? Example Mary buy...
Extending explores
I have done it successfully for extending single explores. But:I have never seen an example of extending multi...
Stream Analytics using Amazon Kinesis or Amazon Firehose
Hi guys!How to parameterize the Looker for Stream Analytics using Amazon Kinesis or Amazon Firehose?The config...
This "connection" is overridden by a "connection" declared in a file included below
I am trying to add an existing view (used in another model) to a new model I am writing. But I get this error ...
Problems writing conditional expression in Liquid with string parameters
I am trying to write a section of conditional logic in the sql: section of a derived_table using a parameter. ...
Join a VIEW in Explore without having a Join/Common Key
Hi Experts,I have an Explore in my Model where I have multiple View joined properly using ‘sql_on:’ I want to ...
Custom Looker Application
Hi,I just wanted to see if anybody has done something as building a custom application within Looker, similar...
I want to sets of drill fields for a measure
I have many dashboards built of one Explore. Most of the dashboards have a set of drill fields for the measure...
Rank
Hi,I would like to calculate the rank in LookMl (i don't want to use table calculation) of my dimension accord...
full suggestions not working
When I add a dimension with full suggestions set to “yes” as a dashboard filter it comes up with “No Results”....
Access_grant, Access_filter
Hi, what is the difference between access_filter and access_grant ? And an example use case. Thanks
Eliminate Null in the LookML Script itself
Hi Experts, I created a dimension, like this which is giving me the right number/Integer, I wanted (8751).. Bu...
Using LookML CASE
Hi Team, I am referring to below link to achieve my requirement.https://help.looker.com/hc/en-us/articles/3600...
Obtaining both a suggested parameter and its label from a different table
Hello everyone!I have a question about (suggested) parameters.For a certain explore, I want the end-user to be...
Manage Explore access for different users
hi i m new to Looker. my company has various dashboard originally letting all users to see, now we want to ext...
Calculate Week Days, Days Elapsed and Days Remaining for Current Month
Hi Team,Can we built dimensions for ‘Week Days’ (excluding Sat and Sun), ‘Week Days Elapsed’, ‘Week Days Remai...
Pivoting by Custom Measure/Table Calculation
Hi, I made a table calculation with a nested if statement to label a numeric column with an interval range (i....
Best way to concatenate in Looker?
Hi ! I’m a Looker newbie and have an initial query that would really appreciate any advice on. I am working wi...
Subtotals in Looker
Update: There is now a custom table visualization that supports subtotals! For more info, visit the table with...
Inline/Isolated table in LookML
Hi Team,I want to create a brand new table in LookML Model, with some values also (some 20 rows may be). The t...
Derived table based off view
hello! I am trying to build a derived table that aggregates another derived table . Is there a way for me to b...
LookML Scripts for MTD, QTD, YTD, Prev Mth, Prev Qtr, Prev Year for BigQuery Database
Hi Team,I have BigQuery as a databases and Looker connecting to it. I am trying to create LookML Scripts for t...
Accessing Explores and Models on a Branch through the API
I’m trying to access models and explores only available on a dev branch through the api, but only getting the ...
Hub & Spoke architecture
Hi,I’d like to re-structure our current data model using the hub&spoke architecture. Are there any guides/docu...
Rich Text support
Does looker support Rich Text in string Dimensions (or elsewhere)?I’m guessing the answer is “no”. But would l...
error create dimension Query execution failed: - Scalar subquery produced more than one element
Hello, please I want to create a dimension that contains all the products that were purchased last year. I hav...
