How to group by using only selected columns in looker?
I have a base table with me on which I am applying the aggregation over the aggregation. How can I make it dyn...
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
Emoji Rendering In Dashboards
I’ve set up a dashboard so that our customers which reach 100% of a metric show up with a green box emoji, tho...
CloudxLab is hiring for the role of Looker Subject Matter Expert- Part time (can be done with your existing job)
Hi amazing people, We are looking for a subject matter expert to train learners around the globe, on Looker vi...
How to create a 'days prior to event date' dimension, to be used in place of actual calendar days?
I have a scenario where I want to compare the a the trend among multiple customer/clients leading up to a cert...
Help with lookml/sql
I’m trying to create this SE name field in looker. It exists on the opportunity table/view. I want to bring in...
RendererNoRenderFinishedEventReceivedError - Looker Dashboard-Next PDF Download/Schedule Issue
I have a dashboard built in Looker-Next. When I try to schedule a PDF or manually download the PDF, I receive ...
Can we use multiple connection in model
Current scenario: Using single connection Multiple tables are joined in explore in the model file to make a lo...
Create a block of code in look ml to simplify maintenance
Hello,I have my explore 1 and 2 In those two explores i join table A,B,C and also many others table.I would li...
Display company Logo on report header with current time on the right top of header
I want to show a Blue band of 1 inch as header and on the right hand side want to display company logo image a...
Replicating Zendesk FRT measure in Looker
Hey!Our team is trying to replicate some of Zendesk dashboards in Looker and we are hitting a wall when calcul...
url encoding comparison operators for dates
I’m trying to use the link url feature to drill to a look. I would like to filter the look based on the dates ...
Converting String to Date
dimension: ticket_start_date{ type: date_time sql: cast(${TABLE}.start as timestamp);;I’ve tried using the fun...
Dynamic field labeling using another field value
Hi All,Has anyone had the experience of using another field value as label for a field. Basically I have a tab...
running percentage of total
I would like to take the running_total measure type [https://docs.looker.com/reference/field-reference/measure...
Prepare Data for CDF Plot looker
i have the following SQL that I would like to use to plot cumulative distribution plot but i can't seem to get...
LISTAGG using different order columns within group
if we create a measure of type: list, is there a way to change the order by clause of the listagg in the query...
How do I set a number of same day_of_week filter
I need to create a day_of_week filter for a report. I know we can create dimension_group to include day_of_wee...
DAG in LookML
Hi team ??I want to know if Looker has a pre-built DAG tool to visualize the usage of certain data sources in ...
Can I create a Dimension or Measure for the earliest/latest date in a range defined by a user in an explore?
I want to create either a dimension or a measure that will capture the earliest and latest dates in a date ran...
Looker setup in local environment
I am learning looker to become a lookml developer,How do I setup looker in local to try out the looker feature...
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?
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...
