How to move one particular look from one project to another?
How to move one particular look from one project to another in same Looker instance?
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
is it possible to add a relative filter to drill fields?
I trying to use custom drilling with html to drill to a look. I’d like to use the date from the original explo...
Drill Fields on View level not working with Dynamic Timeframe
Only 2 hours of trying to find a reason and I realised that when using Dynamic Timeframe: https://help.looker....
How to sum certain rows if dimension contains certain text? (Not in table calcs)
I have some data that looks like this:Group Name Price70450 Facility $70070450 Professional $6870450 Misc. $78...
SQL Derived Table
I am trying to create a derived table with SQL which involves using a liquid condition in the SQL. I used a in...
Multilevel grouping of dimensions and/or measures
Hi Everybody,I am new to Looker. Forgive if its a naive question.Wondering if there is an option for multileve...
Super Awesome Advanced Conditional Formatting Example - From JOIN session
In our JOIN session on Customizing Looker with Liquid, we shared an example of an advanced use case for condit...
How to add a checkbox using html in Looker
Hi there, Is there a way to add a checkbox as a dimension using html in my LookML?The output would be a new co...
Percentage calculation and user clustering
Hello! I am trying to do a few thing in 1 table:calculate percentage from Total Dollar spend despite the filte...
[Analytic Block] Daily, Weekly, Monthly Active Users
Looker has created this block to make analyzing data easier and more efficient. This Data Block is made availa...
Loop through list of fields using Liquid to check _in_query
I’m trying to loop through an array of strings that represent field names in my view to check if each field na...
Conditional formating for yesno dimensions
Hello,I’m wondering if its possible to apply conditional format for yesno dimensions? Here’s my attempt to cha...
Encouraged usage of sql_quote
Hi folks,I have a derived view with some SQL like this derived_table: { sql: {% assign foo = _filters['foo'] |...
Multiplication of rows
Hi,I want to group the data with couple of dimesion, as part of it i want to multiply the rows of a particular...
Getting Error in creating new dimension and measure.
WITH last_run AS ( SELECT max(date_run) as last_run_date FROM analytics_s.firm_stats ), Transaction_sum AS ( S...
How to create QTD chart with QTD change in Looker with BQ
Hi team,I am trying to create QTD period over period analysis by which this kind of chart would be there:Can y...
Changing String Date Type from DD-MM-YYYY to YYYY-MM-DD in Date Datatype
I have a view in Looker which has a dimension Sales date with datatype as String and it is in the format DD-MM...
Incremental PDT's - rebuild entire table nightly
Hi All! Does anyone have thoughts on the following use-case for incremental PDT’s?I have an incremental PDT th...
Percent_of_total with filters doubt
Hey guys! I’m a Looker rookie, so this might have a super easy solution that i may not know about yet. My prob...
Create a filtered dimension in LookML
Hello!I want to create a dimension within a view that is a filtered list of an existing dimension in the same ...
Is it possible to add a measure in LookML explore?
I have two separate views and one explore joining both the views, I want to add a measure in LookML explore. I...
dimension_group auto expansion
Hi, if I have a dimension_group (time) defined, and I apply the ‘group_label’ parameter to group it with other...
In an explore, how can I get statistics of a single table correctly without being impacted by other tables it is joined with?
So I notice that in an explore, even if I just want to get stats of a single table only, when querying Looker ...
How to calculate each refresh of dashboard with BQ
Hi team,I am trying to calculate the dashboard cost or I can say how much data dashboard refresh will access f...
How to round datetime into 1/24
Hi team,I have a date column which has value like 2022-03-29 23:00:00. I need to round it up by 1/24.the expre...
Templated Filters for Dates in Native Derived Tables
I’m trying to implement a templated filter to filter a derived table using a dynamic date parameter, much like...
dimension condition by filters
Well, I have the next problem.I have this variable dimension but the problem is that when the first three cond...
Deriving partition filter from timestamp
I have a table in Databricks that is a time series of sensor readings. The table is partitioned on a column ca...
Get length of selected items in templated filter when some items have commas
I want to base some of my `html` parameter logic on selected values in a filter. My original thought was using...
convert utc_departure_date field in airport local timezone in Looker view
Previous year, the US based organization I work for launched in the Europe. While this was super exciting for ...
