Multiple date formats
Hello, I have two formats of date ( dd.mm.yy and dd.mm.yyyy )in my source data. How can I convert them to sing...
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
SQL Error: Unrecognised keyword CONTAINS/MATCHES_FILTER/LIKE
Hi there,I need some help with case statement syntax. Here, in the below statement ‘category’ is a measure and...
LookML being deleted when setting GIT connection
Hi everyone,lately I am finding an issue that im not sure if its an expected behaviour, but its uncomfortable:...
Generate LookML from database missing
Hi everyone,When I work in my enviroment, I'm able, from the development enviroment, to select "Generate LookM...
Calender Dimension - Lookml
How to compare numbers from the same month but in different years?Is it necessary to make a calendar dimension...
HTML adding up and down arrow to value to cells on table viz (Updated)
An updated version of this article now that 0 %} {% assign indicator = "green,▲" | split: ',' %} {% elsif valu...
Implement vertical "writing-mode" in Looker "Table" visualisation
Hi,I wonder any expert out here can help me please.I have a tabular report in Looker that has one pivoted dime...
Use For loop in Lookml
Hi All,For my use case, I would want to assign a variable whose original value would be 0 but based on a certa...
Rebuilding only a portion of PTD
Hi all,Is it possible to rebuild only a portion of a PDT based on a key? What I need is different from an incr...
Hide/Unhide a column in Looker dashboard
I want to be able to select/unselect columns to display in my looker tabular dashboard. Is there a way I can a...
dimension_groups inside of group_labels get auto-expanded
Hi, if I have a dimension_group (time) defined, and I apply the ‘group_label’ parameter to group it with other...
New incremental linting option in LAMS LookML Linter (v3.1)
Look At Me Sideways (LAMS) is an open-source LookML style guide and linter. LAMS v3.1 has just been released. ...
Is there a way to automatically pull in changes from remote project?
As far as I know, the remote project import feature always requires the user to update dependencies & deploy t...
Looping over a list of Dimensions
So I have the following code using a combination of good ol LookML and Liquid. What I am trying to do is loop ...
Dynamically Change date field in an explore based on the Drill into level
Good day experts. What I need today is on another level. So easy and simple of the surface, but very complicat...
Shared filters/parameters between multiple views used in one visual
Hello,we have two views on two different fact tables joined inside one explore (not the same granularity and d...
Fire off drillmenu:click event without redirecting to link
I noticed there was a similar question but no response so I’m asking myself.Currently we have embedded dashboa...
Set default value on lookml dashboard using another filter (and its associated parameter)
I was wondering if it was possible to create a filter based on a parameter and have the parameters value be an...
Can't edit my own Looker dashboard
I'm using Looker with my GCP account (https://lookerstudio.google.com/). I have created a dashboard, used it f...
looker date filter with timezones converting from datetime to timestamp
I have created a date filter and then want to use the start and end date to filter a derived table. filter: da...
Running Total by Category & Date
How can i calculate running total by category sorted by Date. I know there is option available by using runnin...
Calculate sum of column and repeat value across all rows.
Hello, I am trying to go from this: COL1 COL2 ABC 1 DEF 2 GHI 3 to adding a sum of Col2 to Col3, but so it dis...
Question re: "A Cure For the one_to_many Blues" Article
Hi All,I've implemented the "Join Paths" model design described in Fabio's "A Cure For the one_to_many Blues" ...
Retain Filter selection in Dashboards using temporary storage options via lookml
Hi Team ,Is there any option to save user selection on filters via look ml like a temporary storage of filter ...
When I connected the LookML project to Github, the code disappeared.
Thank you for your help.Thank you for taking a look at my question.I created a new LookML project automaticall...
How to access start and end time of the dashboard filter(of type date_time) in view file
I have one field of type timestamp in the database and have created a filter in the dashboard on that field.Wh...
Visualization for two datasets
Relatively new to Looker, my IT team has created views of datasets which I am then able to visualize on dashbo...
Rolling sum from the same column
Hi All,I have one column A in my table A, the value saved are the sum of different series and I want to create...
Filter with multiple columns
I have 3 columns which should come in a single filter dropdown . But the condition is such that if it is enabl...
Fill missing dates before join
Hello,To provide some context, I’m looking to make an “ARPPU Cohort”, which looks like something like this ;Ba...
