Drilling for non-aggregate fields (type: number)
Hey all,we are currently trying to show relative numbers (i.e. where something is set in relation to the total...
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
Extracting a field info from multiple json objects in an array
Hi,I am using Snowflake in Looker. I have a Items column which has multiple JSON objects inside an array. I ne...
Adding a year criteria to existing custom table calculation
Good day all,Been trying to find a way to add a year criteria to the first ‘if’ statement as per :if week < 40...
File Encryption
I need to store resulted data in csv file with scheduling and that csv file need to be encrypted before schedu...
BigQuery dimension group datetime datatype time timeframe issues
We have a datetime dimension being read from BigQuery, the problem is on Looker it converts the time value to ...
Calculate between various parameters
I have several parameters for a same calculation that i want looker to do in a single row. For example:If 1 50...
LookML examples to implement data tests
New to looker and would like to implement some tests for ETL validation (examples below from @rebecca21 ‘s pos...
access_filter and native derived table
Hello Looker Experts, After adding an access_filter to an explore I get the following warning:Persistent Nativ...
How can I create a column with a sequence for every new id
I need to create a column that counts sequentially an ID column and re-starts the counting every time the colu...
How to calculate YTD for every date period in history and not just as now?
HiI am trying to replicate existing reports which include MTD and YTD measures. I don’t want the YTD as per no...
issue with field_filter extending an imported dashboard
I am extending a dashboard from a remote imported project. I have the base dashboard and extended dashboard wi...
model column names
Looker is pulling Teradata titles instead of column names. Is there a way can I get only column names into loo...
Explores with reusable logic?
Hello, I have a number of explores using different views with similar structure and having exactly the same jo...
Dynamic named_value_Format
is there anyway to make this code work from this thread: https://community.looker.com/lookml-5/dynamic-value-f...
Two views, same fields, can I show all rows in one Explore query?
ContextI have two views - `call_speed_of_answer.view` and `call_abandonment_rate.view`. They extend a `call_ba...
Is it possible to reference the value of a filter parameter?
I believe I did this before but cannot recall how or if I did at all. I am interested in referencing the value...
Calculating Rollup Revenue
HiI am trying to calculate the rollup revenue in looker, I have multiple levels of hierarchy so the Revenue sh...
Where are the SQL Runner line markers?
Hi. Anyone else having trouble in finding number markers on SQL Runner lines? Look how my Looker woke up today...
Cosmos DB connection
Hello. We have the need to connect to a Cosmos Database and I see that Looker does not support that type of di...
Actions and Gathering Feedback on Data
I am trying to create an action for my dashboard to gather feedback from users and write it back to the BigQue...
Strange warnings when using constants in Dashboard LookML
Hi community! I’m working on a project using the SA 360 looker block and I’m trying to use constants to make t...
Formatting Table Drilling without Visual Drilling
I have a simple drill containing a percentage column.When this drill is accessed, the percentage column has a ...
How to subtract month in lookml
Can we subtract months form ${created_date} in lookml. Eg: ${created_date} - 13 Monthswhich should give me the...
LookML Developer Certification Exam
Hello all,Would anybody know if there are any (preferably free) resources to access past exams for the LookML ...
Case/when based dimension: Want to filter more efficiently
I have a dimension that is defined as follows: dimension: product_id_group_biz { label: "Product Business Grou...
how to apply filters based on a list - user in (select distinct user from t)
heyi’m presenting a dashboard based on users action - i.e. calls to costumer case (CC)Imagine that i want to s...
Emulate a function call in LookML
Figure out this SQL code:SELECT client_id, fn_getComplexCalculation(client_id, DATE(“10-01-2020”), DATE(“10-01...
How can I drill down in Looker?
Hello! Let's suppose that I have a table with 2 columns: date and sales. Then, I created a graph, where the X ...
Adding Multiple Instances of an Extended Dashboard within a Single Dashboard
I am working on a dashboard (let’s call it alpha) that is using one report (daily_values), multiple times, but...
Filter to always have OR 'field' IS NULL
Is there a simple way, without going into creating separate parameters and sql_always_where to set a field to ...
