Post result of a table as view as it is
Hi, Im exploring Looker for first time, I have a simple requirement to publish query of table as View so that ...
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
As per best practices, is it advisable to have different files for all views or have them added to a single file?
HI, Does it makes any difference if I have different files for all my views or have them consolidated in one s...
LoV of Dates, Conditional Filter
Hello everybody I have a customer who extracts data at irregular intervals and stores it in our DWH. Now I am ...
Push Changes to Remote Failed
This error I receive after I commit the changes. Also next text appear: refs/heads/dev-sergiu-boboc-mvvv REJEC...
FLOAT can't be used as dimension in pivot tables (BigQuery)
I came across the need to show a floating point coefficient in the rows and then use it in a calculation to ge...
Not able to import LookML dashboard with Static Layout into user defined dashboard
I am not able to import LookML dashboard with Static Layout into user defined dashboard. Please suggests hpw w...
get number of orders per store per week in buckets
Hello, I want to get the number of orders per store per week in buckets, using dimensions: week, store_id and ...
Field value formatting - square
Even though it’s a specific question, I would also like to have a thread where we can show some interesting an...
Concat Specific Value to Column Names
Hello, I have a table with a date column as well as a few measures. In all cases, users would only be able to ...
Limiting drill from a dimension / measure to some Looks
Hi all, I have a requirement where I need to enable drilldown from a dimensional attribute to a different dash...
Drill Total, Year, Month, Date
Hi I have the requirement to give the possibility to start the date drill not with the year, but with the tota...
View not found error in Looker
Hey All, I have deployed my model into production.The users then can see the dashboards and changes i have mad...
set: Not Appearing in View
When I create a set: in a View, it doesn’t show up in the View when I go to Explore it. Is there an admin sett...
date dimension comparison with date range
Hi I’m using a derived table view with this conditional clause below. How do you translate this from snowflake...
Filtering of schemas
I have a use case where we have multiple schemas in a connection. Each schema contains views that are the same...
Duration dimension_group - Unexpected Results
Is there a way to force the grain when using Duration? When using only a Duration of Days, Looker still DATEDI...
Make use of filter operator (is equal to, contains, etc.) within Liquid statement
Hi Liquid variables are quite powerful and really useful. Is there and way to get the filter operator (is equa...
Using Postgres and JSON Functions and Operators to parse JSON fields
Any SQL functionality that is native to your dialect can be leveraged in the sql: parameters within LookML, or...
Metadata and explores
Hi I’m after a way to list all the fields - dimensions and measures - exposed (not hidden) in all explores in ...
MEASURES AND DATE FILTERING
I have a formula where I have to first find the max and min dates within a month against the data, then use th...
Custom Measure based on logical OR of 4 dimensions in table
I am working with a table which has 4 related dimensions (let’s say A,B,C,D) any of which may be not null. Now...
Auto Populate allowed_value: in Parameter/Filter-Only Field
Is it possible to query a table, and load all the results from one of the columns into the allowed values of a...
Postgres (P)DT Performance Tip
I’m currently working with a client where Postgres is used as the data warehouse DB. One of Postgres’ features...
Measure filters not working with more than one "-Negative" Filters
measure: total_gross_revenue { type: sum sql: ${amount};; filters: [invoice_item_types.name: "-CREDIT_TYPE", i...
Auto Delete PDTs
I’m using persist_for and sql_trigger_value to create PDTs for some complex queries in TeraData. But enabling ...
Arbitrary Period Comparisons
Google Analytics has a date selector that allows for comparison of two arbitrary time periods on the same char...
Where datagroups live
I’m trying to update https://github.com/ww-tech/lookml-tools's linter. I’m coming across datagroups for the fi...
Help With Templated Filter and Liquid
Hi All, I’m trying to create a derived table that lets me input a date and pull value from 7 days prior to tha...
