LookML order month name by chronologically
For the dimension time frame, I want to sort the month name by chronologically. how to edit the code below? di...
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
'To-Day' Filters While Comparing PoP
I am trying to create a dashboard where the user can select a date, and the single-value tiles would then show...
custom filters for two or more tags
Hi, My name is Alex,I am making a custom filter that I hope will return the number of people that have two tag...
PDTs in Looker vs DBT Best Approaches
Hi, I’m working on a project that has tech stack - Snowflake - DBT - Looker setup already. Snowflake is the ma...
Machine Learning
Machine learning is a subfield of artificial intelligence, which is broadly defined as the capability of a mac...
SQL error in derived table
Hi,I am connecting to an Athena database. I have created an array which simply lists the dates from 2000 to 20...
Assign bar colors based on attribute value
Hello. I am looking to assign the color of bars based on attribute values, within the LookML. I know this can ...
Create dynamic time frame for dimension group
I want to use parameter to allow users to change timeframes on the dashboard so they can choose between rollin...
Unexpected ELSE in parameter
I have the following parameter code block: set: absolute { fields: [ 10th_percentile, 25th_percentile, 50th_pe...
Calculations on whole dashboard using LookML
I would like to create a parameter in LookML which normalises all the metrics on a dashboard when selected. So...
Percent change from the last row
How do I calculate percent change from the last row of the result table?(For example, percent change from firs...
improve performance in looker derived table
I have a question about how to improve query performance in looker. I use derived table in looker to transform...
Reusable Table Calculations defined in LookML layer (new field type)
Lately I find myself wanting to use a measure of type: running_total in another measure. Things like that are ...
Sum Of Two different type values in Measure
Hi All,I am having problem with sum of two different type values .example : i have address_type like current a...
Am I able to move the filters to a different area?
So this is my first time using looker for a client and their style guide has a sidebar that has the filters on...
Elegant solution for Missing Values in numeric dimensions?
Hi all,I know there’s a few solutions for this, but they feel clunky and am wondering if I’m missing a more el...
Parameter to select set of metrics or do a calculation on multiple dimensions
I have a set of metrics that I want to visualise on a dashboard or exploreI would like to have some way of eit...
Use default value of a field
hi, i have this measure that depends on the field view_limit_quantity_daily is defined or not.If the field is ...
Multiple drill downs on filtered measures
Hi everyone, I have been using the link parameter to create multiple drill downs options for my dimensions and...
Convert string value (DD/MM/YYYY HH:MM:SS) into timestamp in LookML
I have date and time field (DD/MM/YYYY HH:MM:SS) stored as a varchar in my database. Need to convert this into...
Does anyone know how to code custom dimension to get "week_end_date" as a new dimension? Versus week_start_date.
Hello Looker community,I would like to find a way to create a new dimension grouping data for a datatype date ...
How to load csv file present on developer local drive to Looker?
I have access of Looker instance and I use my company email to access Looker. I have a csv file which is local...
How to connect Looker with SFTP server location?
HI team,I want to extract csv files present on SFTP server. I have SFTP server host name, credentials. How Can...
Group by
I am trying to create a scorecard which shows Store count if the profit > 80%.Can you please tell me how to wr...
Aggregate awareness exact match
Hello all, I have order_item Explore with the below joins:order_item ----- (many-to-one) ----- order ----- (on...
Passing parameters to extension via dimension link
In my manifest.lkml file, I have following extension: application: resend_email { label: "Resend Email" file: ...
Preventing Measure from overriding order_by on Dimension
Hi,We’ve encounted an issue described below: - If I have a dimension that I have specified an order_by clause ...
Convert_tz ignored when filtering dimension of type DATE
I have this fairly simple dimension I use for filtering type: dateallow_fill: noconvert_tz: nobut the time zon...
Measure not working with total option.
Hi All,We have a count distinct measure and which is working fine without total option but if we check the loo...
Outer Join on False - or: How I learned to stop fanning-out and love the NULL
Note: Although everything demonstrated in here is basic SQL, there are notable dialect considerations. TL;DR? ...
