create filter to selected date
Hello please I created a filter to select a date and calculate the measures based on the date chosen.my databa...
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
Casting string to date
Hi,I have a date field in the format yyyy-mm-dd and in string type. How do I convert the string type to date t...
Dynamic measure with date selected by the user
Hello,I would like to create measures with parameters allowing the user to choose the date (month and year) th...
Field replacement in merges
I renamed a field in a LookML view from myview.old_field to myview.new_field.I used the Content Validator to r...
Comparing dynamic weekly data with static benchmark
Hi Everyone!I’m looking for support on a quite simple calculation (I believe). Many thanks in advance for your...
Refer to Priority Flag if Column item is not unique
Hello,I would like to filter the data in Looker based on the price per city.For example: the result should be ...
Converting epoch date to yyyymmdd dimension for exporting purposes
For external reporting purposes I need to convert the epoch date to a yyyymmdd format.I used the liquid logic ...
What is the value_format of negative percent?
I have a measure which would turn out to be a percentage of negative values e.g. -40%. The value_format I put ...
How to create a relative timeframe from column data and do a YoY comparison with it
I recently created a Look that seems that it might not be common knowledge but is a possibly common scenario. ...
Use User Attributes to set derived table name dynamically in sql_table_name
Hi,I try to set the derived table name like ${derived_table.SQL_TABLE_NAME}, in user attributes and use it in ...
Date filter syntax & sum measure to provide recent {n} {interval}
Paraphrased data model: I’ve got an `accounts` table which `has_many` snapshots.Each snapshot has:account_id m...
How to calculating the median of a duration?
I’m at a loss as to how to do this as it’s throwing an error in looker … I have 2 dates were i’m calculating t...
Converting number to string
HIIm calculating the length between two dates as a number, and then i want to convert it into a string to be a...
Add Hours based on different conditions (Case statements)
Hi Community! I am bit new with lookml So please bear with me :). I want to create dimension_group where in i ...
Changes in master branch with git
Hi,I have done some changes in master branch with our git interface to recover a previous version of one file,...
Show/hide columns (measures) on looks based on condition (dimension)
Hi,I am creating a dashboard and the looks composing it are several. One of them should show the same basic se...
Pivot functionality creates NULL values
Using pivot for one of the dimensions creates null values in metrics that have coalesce and CASE WHEN IS NULL ...
Looker Default caching policy
Hello Looker Community,I am trying to understand how Looker default caching works. This is what I have underst...
Manipulating string in a filter
I want to filter my table based on a user input value and to achieve this I am using templated filter:view: po...
Looker best practices - all in once place?
Hello Looker Community, is there any place where I can find ‘looker best practises’ all in one place? (step by...
Passing parameters into PDT
HiI’ve got a question regarding Solution 2 in this articlehttps://help.looker.com/hc/en-us/articles/3600238616...
String to number in Look ML
Hey there! A google sheet I imported unfortunately shows all my values as strings instead of numbers in Looker...
How To: Smart Partition Key Filtering with Liquid
Problem: We have multiple partitioned tables, and are joining them into an explore. To improve query performan...
Missing pages/looker block code
Since the rebrand of this community, there are some pages that seem to have broken, especially from Looker blo...
How to use Regex Extract in SQL Runner
Let’s say I have a column “URL” which consists of URL paths. e.g. “https://community.looker.com/topic/new?fid=...
How do you add multiple liquid variables to a link in Looker?
I’ve followed this link https://docs.looker.com/reference/field-params/link on how to add a link to a dimensio...
How to create a measure to calculate max(date) per ID filtered by a value of dimension
Hey guys,I am trying to create a measure for date field. Below is the current view in my explore:Current ViewT...
JDBC Error: Cannot connect: connection refused: ... The connection attempt failed
This database connection error is often difficult to troubleshoot, given how non-descriptive and vague it is. ...
Date formatting
Hi,How to change the date format from ‘02-jan-20’ to ‘2020-01-02’ in the dimension?
SQL Exists, or IS IN functionality.
Wanted to get a list of customers who fit a certain criteria based upon an orderlines table.The table has a co...
