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...
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
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 ...
Replicating Google Analytics Internal Search Statistics
Hi all, new Looker developer here asking for help.I’m working on recreating a set of measures to replicate GA ...
GitHub Flavored Markdown - no LookML syntax highight?
Our org has recently switched to GitHub and one feature our team was excited about was the GitHub syntax highl...
Extract time from datetime field in SQL Runner
Like the title says, I’m trying to extract the time field from a datetime field. Datetime is standard format o...
git commit hook validation
I like to work with my IDE in looker and would like to run a validation on the files I am editing:every time I...
Map with a single datapoint: not supported?
Hello folks, I’m trying to plot a single datapoint (lat+long) on a map, but the end result is pretty much unus...
Sum of unique users that...
Hi! Let’s say I have a view looking like the table below. The table shows the Customer id and what store they ...
Filter for "end of month"
How can we filter a date dimension which shows data for “end of each month”For eg: How can I filter the “date ...
bigquery daily shared tables and different date selectors (ga4 app exports)
Hi there, we are trying to set up a GA4 bigquery integration (marketplace block does not work, we have too man...
Do we have a API to create view files from table?
Just Like in the online IDE?Or create view files by some conf?I am trying to work with generating the LookML c...
LOOKER API -SPRING BOOT INTEGRATION ( WITH JAVA LOOKER SDK)
I am trying to connect my Spring Boot Application with Looker API, So I have used the Looker Java SDK for the ...
Dynami date filter
Actually i have a requirment where I need to use the date filter which has quarter values only .So now require...
Creating constants from a json file
I was wondering if it was possible to consume data stored in a json file as constants that we can then use in ...
how to show missing data or null values in if statement
I’m creating a custom dimension on looker and need to type if statement but in the if statement I am not sure ...
Get more than 1000 suggestions in drop down meny
Hello, I have a case where I would like more than 1000 suggestions in a filter (~1400 to be exact). I really w...
