How to comment out a block of code
In order to comment out an entire block of code in the LookML editor, following these steps: Select the lines ...
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
Parse string to date using 'Custom Dimensions'
Hi TeamWe have a column in database that is a string format of date eg: “2022-01-19T00:00:00+00:00” and we lik...
The lookml validator does not raise a warning or error when there is a typo in relationship
Hello, I hope this is the right place to raise this issue. As per documentation the syntax for relationship is...
I'm trying to calculate the percentage, COUNT(ABC) when Filter = "xyz" / Count(ABC) with no filter
Hi,I'm trying to calculate the Counts and Percentages in a table.Filter: Field contains "xyz"Count(ABC), Perce...
Ideas for displaying NULL values as 0
It’s not uncommon to want to display ‘0’ instead of NULL. Does anyone have any good techniques for handling th...
When is convert_tz: no ignored?
Looker documentation highlights the below nuance about using convert_tz: no. However, in my testing, I do not ...
Value format in looker. We are trying to break number in billiion, million and thousands dynamically
Folks,We are trying to format numbers in Looker dynamically in billions, million, and thousands dynamically. B...
Dashboard access by using User Attributes
Hi Friends, I have a requirement like have to provide access of a Dashboards by using User attributes.I have c...
Looker Aggregation of Measures
I am trying to create a measure of type count_distinct and I want to use it in another measure using type sum....
Prevent Automatic TO_CHAR()
Using Snowflake backend. I’ve got a dimension like this: dimension: orderdate_ntz_param_tz_offset { type: date...
How to add filter in SQL derived table
I have this sql derived table to show the distinct values of 2 columns (TOP_1 and TOP_2) and I want to add a f...
Using constants to define allowed values in a parameter
Hi,I have a use case where I need to use the same parameter, containing multiple allowed values, across multip...
Dynamic Connections for Models
Is there a way to dynamically change a connection in a model so that we can take advantage of Snowflake secure...
Set model connection name dynamically
Hi,I cannot believe this is so difficult to find an answer to.We are embedding Looker dashboards via SSO signe...
Syntax error: Unexpected keyword WHEN
Hi I'm trying to calculate the occupancy rate of my hotel but i just can't figure out the correct form. This i...
Dynamic Button
I am looking for a way so that I can have a button in my looker dashboard clicking on which will take the user...
Customization in Looker Studio Visualization
I've started using Looker Studio and wondered if we could have time-based visualizations like timeplot or scat...
How to replicate "userelationship" (power bi) in looker?
Hi guys!The problem I’m facing is that in one fact table there are two dates:-Start date-End dateSo, in power ...
How to merge different derived tables
Dear experts,I need to merge 2 different explores but I don't want to do it in the visualisation process but w...
Dynamic derived table based on filter
Hi Looker expert, I wonder if there is way to access the filter value inside the derived table sql statement? ...
MERGE ERROR GOOGLE SHEETS SQL SERVER
Hello everyone, I was trying to combine data from two data sources, the first one comes form SQL Server, and t...
How to: Revert to a specific commit, no git commands necessary
Prerequisites:Must be on a version that supports advanced deploy and have it enabled Your Looker instance must...
Search multiple substrings from multiple columns..
Hi, I have two columns in my source data, one a measure and one dimension. I've written below a code to find m...
Create Chart to show new hires vs. resignations by month
Hi,I'm very new to Looker and this is my first post. What I need to create is a chart that shows new hires and...
Dimension to Handle Array Type data in Lookml
Hi,I have a table >500B rows. DBA has put a rule that the table can only be queried with a where condition on ...
Qualify in LookML - Workaround
Hello! Attempting to use the “QUALIFY” sql statement (working with Snowflake), I found pretty tricky but elega...
Easy way for suggestable values that are not necessarily in output data?
I have an explore like the following:derived_table: {sql: select distinct account_id from table where state in...
Method in LookML to calculate period over period trend calculation
Hi All, Please find below my requirement which should create a dynamic filter on top of a existing view. We al...
[Analytics Block] LLMs in LookML
Do you want to enable your Looker users to leverage large language models on your text data? This analytic blo...
Advanced Permissioning Using User Attributes
Advanced Permissioning Using User Attributes About This Pattern: This analytical pattern can be used to set a ...
