Convert UTC to local time zone in Looker (have bigquery database)
I am not able to convert my UTC timestamp column to a local destination timezone using a different column in m...
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
does deploy to production apply to all the lookML projects
When pressing the button of deploy to production in the specific project in looker, will it also merge my pers...
HTML Class Library
Do looker have any doc or library for visualization class like:class =”vis”class =”vis-single-value”Where we c...
How to remove transparency in Looker filter?
Currently in our Looker instance we have a grey background setup. However, when a Looker Filter is not selecte...
aggregate data download log
Hello,I wonder if there are any ways to check the users who download the files from the lookml/user-defined da...
Dimension does not execute in explore
I have:dimension: fl { type: string sql: CONCAT('flt-', ${departure_date}, '_' , ${oa.iata}, '-', ${da.iata}) ...
Customizable drop downs using the HTML details tag
Using the HTML syntax it is possible to create drop down buttons that can display additional information relat...
Create a custom filter that defaults to current week Sunday to Saturday
Hi Looker geniuses,Is there a way I can create a custom filter that defaults to the most current week from Sun...
Warping the render value in Single Value Vis. via lookml html
I'm trying to make a tile in dashboard were value will be rendered through Look ML html via a single value vis...
Passing Dashboard filter as a parameter
As the title suggests I need to pass a dashboard filter as a parameter instead of a filter for a look. Is this...
Access Grants
I have user attribute department defined in my looker instance.I have added this code to a model:access_grant:...
Feature request - SQL WHERE but only if joined
Sometimes I have two simple views connected to each other but since it’s LEFT_OUTER, there may be some entity ...
How to select columns dynamically in a filter
I have a existing report which needs to migrate into looker in which one filter values are having the column n...
Looker Integration with Cosmos possible ??
We need to connect to Microsoft provided Cosmos DB with mongoDB API client. It looks like Looker doesn’t have ...
liquid式の参照できるviewの範囲
使用しているSQLデータベースはBigQueryです。liquid式で {% view.field_name._is_selected %}を使用していますが、こちらの参照できる範囲はjoinが定義された同じExplor...
Add special character in dimension name
I need to add special character in the dimension: #_OF_IQ_SESSIONS { } but i am getting bellow error : “ Inval...
Syntax error
CREATE TABLE STAFF(STAFF_ID VARCHAR(20)STAFF_TYPE VARCHAR(30)SCHOOL_ID VARCHAR(20)FIRST NAME VARCHAR(100) NOT ...
Difference between rows for A/B test
I am trying to build a dashboard to assess performance of A/B test (test vs control group) for campaigns. This...
How do I average a daily count over week or month in looker where I need to join the data with other tables
I am new to Looker.I have a table with a count of distinct values grouped by day.I’ve imported into Looker as ...
"Must provide a field name for parameter" error message
Hi, I’m trying to create a simple parameter to choose between 2 dimensions to breakdown a view. I’ve copied th...
How to map UK postcodes
Hi,I’ve pulled through UK postcodes of the data type character varying and in the format ‘LE184NG’Upon adding ...
How to create Native Derived Table with brand wise Rank() over order by Sum of Sale price.
Here I want to create rank column with help of Sum(sales) aggregation value in the same query. select brand, S...
Hide Fields in Explore if All Values are null
Hi Looker Community,Is there any way to dynamically hide dimension or measure in Explore if the values in that...
Is there a limitation on number of Model in looker
We have an use case where we want to create a model which contains user defined attribute for each customer. S...
How to create logical filter by grouping them into Regions
Hello,I am new to looker and stumbled upon a Filter requirement. I have a field ‘Platform Name’ which has attr...
Loading historical data using incremental PDT
I have an incremental PDT that loads data on a daily basis. However when I deploy the same to production I wan...
Looker Platform Owner - HIRING - UK - 2500+ user Instance
Looker developers are still relatively niche, Looker developers with experience owning implementing and/or mai...
Look ML
I do not get any error while passing a date range to ‘rev_rec_date’ in SQL runner, but getting an error ‘:inva...
How to convert table string column(which is having time stamp in 1609999 format) to date format in looker
I have table which hold timestamp in number format but the data type of the table column is string.How to type...
Data connection
If I remove an existing connection to my data in Looker, will the data still be available?
