'Datagroup Maintenance Schedule' vs. 'interval_trigger'
Hi Looker Community,Can someone tell me what is the difference between ‘Datagroup Maintenance Schedule’ in the...
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
Rolling 30 day count distinct
Hi Lookers,I am trying to get the count of unique who made a transaction in a 30 day window starting from any ...
How to make sure all regions are updated when I push my code to production?
I have Looker for 4 regions. Whenever I push some change to production I have to manually go and pull from pro...
Is there a way to hyperlink URLs in data visualization tables, without editing any of the SQL code.
I have a calculation where I use the concat function to put together to strings to create the URL that I need ...
Using SQL Runner to pull data - How to Pivot within Query
I’m writing a pretty basic query in SQL Runner that goes something like this:Select id, amount from transactio...
Why would anyone put a test in a View?
According to the documentation here, tests can be placed into a View file but this seems counter-intuitive to ...
Average Reference Line - does not take null values into consideration
Hi, I was using the ‘fill in missing dates’ feature on my graph in order to have a trend line of our metric, a...
Rolling Average Daily Active Users - Redshift with a Cross Join
Note: there is a newer version of this analytical pattern available: [Analytic Block] Daily, Weekly, Monthly A...
Is there a way to change the column name dynamically based on filter setting?
Hello here,Just wondering if there is a way to change column names dynamically based on different filter setti...
Active Chimp
Can we make an app using the flutter and for bigger platforms like nft and the metaverse ? The language is use...
Measures from separate Views
Hi there,Suppose I have two tables, Revenue and Expenses, where Revenue has a measure named rev, and Expenses ...
What does Pull & Merge other changes do?
Hi experts,I feel that Pull and merge other changes are actually doing something else and breaking git.I have ...
Multiple models in one project
Hi,I’m new to Looker and I’m trying to figure out how to have a project that uses more than one connection.I h...
Accessing View date_time parameter from Explore
Hi there,If I'm looking to add in a date criteria to the sql_on parameter in an Explore join, am I able to lev...
Open Rate/Click Rate
I am trying to calculate the open rate/click rate from a field called “actions”. Within the field “actions” I ...
Filtering out inactive records at the View level
The ask is to find out the best way to pre-filter out inactive records in a view file. Right now we are using ...
Group_label is not following alphabetical order
I’m using liquid to determinate these group_labels, but some of those options are not following alphabetical o...
Millions and Thousands Separator
Hi Guys, I have a measure value as distinct count of transactions, and now I want to show the values based on ...
Derived Table vs Table Calculation
Is it advisable to use the table calculation instead of Derived table as best practice in looker especially wh...
how to use partition by windows functions in Looker instead of derived tables
suppose we have a table belowDate Prod Prod_count 18-07-2022 C 1 18-07-2022 A 2 19-07-2022 A 1 19-07-2022 B 2 ...
what are the pros and cons of using derived tables
what are the pros and cons of using derived tables
Filter used in PDT is adding condition to outer query. This breaks the query.
We have a filter that looks like this filter: date_filter { type: date sql:date between {% date_start date_fil...
Can deployed feature branches be removed from branch list?
Can the feature branches that have been deployed be removed from the shared branch list that is viewable in Lo...
Using URLs and Query Parameters
Background on the URL In Looker pre-3.18, the url is a long list of parameters which includes the fields, filt...
Use different locales for each timeframes
Greetings!I am currently applying a locale to my dashboards. Everything is working fine, except for that.I hav...
Replace 0 with null on column
Hello,I am trying to change some zero values with null because they show on the graph and they look ugly. I ha...
Custom filters/parameters: Select a complete full month
Hello,I have created a dashboard where I want the users to be able to compare period over period, specifically...
Downloading information from LookML
Hey all! I would like to know if there is any python script that allows me to connect to Looker API and downlo...
DAU and MAU as measures for a "not" aggregated table
Hi, I am new to looker so please bear with me. I am trying to make the DAU and MAU for my company. I tired thi...
value_format result is wrong
Looker Version:## Contextvalue_format definition: 201 seconds to mm:ss should be 03:21.3 * 60 + 21 = 201;But t...
