How can I create a measure which provides the statistical mode?
I want to create a measure which will calculate the statistical mode for a given value.The SQL equivalent woul...
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
Change Looker Div Class looker-flavored-markdown in Document
We have several documents for tile documentation using HTML that are receiving a parent DIV Class from Looker ...
filter a foreign measurement
Hello, I have to create an array based on the values of a filter on the field of a single view to calculate ...
OR in filters EXPLORE
I want to make an OR filter in an explore. The only option is an AND in the filters
Dynamic Filters (Range)
Hello,I m workin on a task where I need to allow the program numbers to be entered by users dynamically. i.e, ...
Dynamic Joins based on filters
Is it possible to use Liquid to dynamically define a join in an Explore based on certain filters? For example ...
problem of calculating measures in foreign views
Hello, I would like to calculate the total of a measure (sum_dig_total_ht) in a foreign table but the displaye...
fiscal month order by month
Hello, I want to compare the months of 2 year n vs year n-1 and display the results for each month starting wi...
fiscal month
Hello, pleasei want my year to start with april in all my charts. Thank you
Fiscal Month Offset Parameter 4.8+
Beginning with Looker 4.8, we introduced a new model level parameter called fiscal_month_offset:. This will al...
Derived table from join of three tables
Hi,I’m very new to Looker and am having difficulty locating documentation on creating a derived table that joi...
bring field descriptions from BQ
Hi!I can’t find anything related to it and I am sure we should be able to do this.How can we bring the descrip...
Dynamic filters (List of numbers)
Hello, I have a requirement where I need to allow users to enter program numbers dynamically and I should take...
Optimize sql query
Hi, please how to optimize my sql queries to get results faster. I have a model with only 2 joins but when I r...
high latency
Hi, please how to optimize my sql queries to get results faster. I have a model with only 2 joins but when I r...
Pop Analysis Method 4 (Compare Multiple Templated Periods) - Period Issue
Hi! I recently implemented Pop Analysis Method 4 (Compare Multiple Templated Periods) in an explore. It works ...
Has anyone successfully created a View for Redshift stl_load_errors table?
I want to analyze the errors we are getting in our Redshift stl_load_errors table.In my development environmen...
caculate cumulative total month by month every year since 2010
Hello,Please I want to create a dashboard calculate :the turnover month by month and the cumulative total of t...
Show Total regardless of any selections/filters
HI All,I need to show the Total Sales and the total sales should be shown always even when we filter using any...
Caching same query definition
The caching guide herehttps://docs.looker.com/data-modeling/learning-lookml/cachingstates that:"When a new que...
Custom Filter Request
The overall goal of the look I am going to create is to pull a list of accounts that have sent their first vis...
How to calculate Sum of averages for different level of detail?
We have information in a table with Sales by Invoice ID which is mapped to a Location and Area. Like below:Inv...
Snowflake and Looker Date Transfer Issue (snowflake time zone related) - about timestamp_ntz
there’s multiple data types available in snowflake - Timestamp_tz, timestamp_ntz.when we use dimension group f...
Any plans for a Prettier plugin?
Prettier would really help to achieve consistent formatting.
Dynamically choose the table using Date filter values without adding new filters/parameters.
Hello All,I have a derived table for monthly data and a dashboard based on that. But when users are trying to ...
Using parameters through nested derived tables
Hi, I have a base view (View 1) that is populated with a SQL statement. I used a parameter to update some valu...
SQL alias conversion in LookML
We have only one date column in database but two different references (alias in SQL) need to be made out of th...
Rank
Hi, i want to calculate the rank and i have the error as you see in the screenshot.Thank you
error derived table
Please, I want to create a derived table and bigquery as the database and i have this error :Query execution f...
Cache policy by date filter?
Is it possible to set Looker query caching based on the value of a date fiilter field?For example , most of ou...
