UTC date and hour data to different timezone based report
Need help with converting UTC date partitioned data into a different timezone based data/report. | date (DATE)...
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
Week of Month in Month over Month
Is it possible to use the timeframe to create a week_of_month like a week_of_year? I need to show a graph of M...
need date range to sort as per dates not string
I need to showcase a date range (start date - end date) (as a dimension) in the format ‘Month Day, Year’, and ...
Dimension using GROUP BY from View
Hi all, I have a view: my_app { … dimension: time { #… } dimension: device_id { #… } dimension: todo { # SELEC...
Set up Flexible Retention Analysis without Derived Tables
Retention is a metric to understand how many users return to your platform after the initial conversion. Reten...
Set cache for calendar month based reports?
A lot of the reports generated by our Looker system have a whole calendar month time filter Is there a way to ...
How to Use ThetaSketch for COUNT DISTINCT on Druid?
When we are trying to do COUNT DISTINCT, it reports Remote driver error: QueryInterruptedException: Incompatib...
ASK: Filter Boolean on Measure
Hi, I have issue with creating measure on a view. When put into explore, the query doesn’t run because the fil...
ASK: New To Looker - LookML Model Query Cost Optimization Tips & Tricks
Hi All, I’m very very new to looker, excited to be part of the community and learn from you all. Would be grea...
add_days produces erroring DATEADD
I’m trying to add a custom dimension to bucket days by groups of three and still have the column values be dat...
Dimension/Measure/Parameter Naming Conventions
Can anyone share some pros & cons for using CamelCase vs lower_case for naming Dimensions, Measures, and Param...
SQL runner search function change
Hi all, Our search function in SQL runner has changed from: to: The problem is that before when entering value...
"fields:" Parameter Misbehaving
I have this very simple scenario. Here is the View: view: Customer { sql_table_name: "DBO"."CUSTOMER" ;; dimen...
Creating a waterfall chart of only measures?
Hi, I am trying to create a waterfall chart but have been getting stumped unfortunately. According to this pag...
Extend view with conditions
Hi All I would like to know if I can create an extended view, with conditions in the extend on what it should ...
Column headings based on pivot row
I’m trying to write some LookML to have column headings in a visualisation show the value of the pivoted row a...
Explore that joins a table with max measure
Hi all! I have two tables: 1) Customer and 2) Customer phone numbers. Each customer may have many numbers but ...
Variable to store values in lookml
Hi, I need to create a variable that stores a fixed value based on a measure. An example is the total orders I...
How to create a dimension of date type with custom cohorts?
Hi there, I’m still getting used to Looker but came across an issue where I have gotten stuck. I’m wondering i...
Error: firstName_s folder
Looker 7.0.17 show firstName_s folder instead of my name
Count distinct by user within a measure,
Hello, I am new to Looker and I may be on a wrong track but I created a view which is made up of 3 columns: id...
PDT cache being dropped after PR merge
Hi, there we have noticed, couple of while ago actually, that everytime that a PR that affect a PDT’s SQL is m...
[Analytic Block] Weighted Medians in BigQuery with UDFs
Weighted Medians can be pretty helpful in data analysis. The example we are going to use here is the Names, po...
BigQuery UDFs in Derived Tables (or sql_preamble in Native Derived Tables)
I’ve developed some BigQuery UDFs (to remove non-business time between two timestamps) that we’re currently le...
Passing Literal Values to Predicate
We have a BigQuery table partitioned on date. In order to take advantage of the partition, we need to pass the...
Custom measure on system_activity model
Hi there, is it possible to make custom measure in system_activity explore ? For example, to fetch latest Sche...
Measure vs. Computed Dimension
What is the difference between a Measure and a Computed Dimension? In what circumstances would I want to use o...
_TABLE_SUFFIX between
Hi, I would like to choose specific start_date and end_date by a filter as where condition. SQL I used - {CALE...
Selective inheritance of measures in views
Hello, We are modelling our Looker explore by using multiple extends to reuse our measure definitions across d...
String contains key:value pairs. How to extract value for user-provided key ?
Backend: Redshift table; the column C (varchar (1000) ) has data like this: A1:B1&A4:B7&A9:B12 It is basically...
