user selected value in query as filter
I am trying to create a derived table based off the below query on Looker. Except, I want the user to choose t...
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
creating a measure to find # of users with X # of rows in a table at a time grain.
i’m looking to get the count of users with more than one ticket in a table that is at the ticket grain. So whe...
LookML error: The field "fieldnamehere" is of type "string" but is listening to a filter of type "field_filter" that specifies a field of type "(?)"
Hi, I am getting this warning when I validate in LookML. I have a filter for currency (filter name: Currency)....
How to convert string to timestamp in looker
Hi team,We have date string as 20210131120101(YYYYMMDDhhmmss) in table. We want to interpret this string into ...
Date Label Issue
Hi Community,I am new to looker. I have mapped in a new model and in the view there are a number of Date field...
Deployment strategy that involves not breaking existing content
Heya!Would love to know what deployment strategies are folk using in order to deploy graceful changes.To give ...
'Datagroup Maintenance Schedule' vs. 'interval_trigger'
Hi Looker Community,Can someone tell me what is the difference between ‘Datagroup Maintenance Schedule’ in the...
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...
