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...
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
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? ...
Scoped user attributes do not resolve to a value
I followed this document on how to create scoped user attributes: https://github.com/LukaFontanilla/luka_exten...
Change Looker suggestions query
Is it possible to change the Looker suggestions query? I would like to add a “WHERE”...Thanks!
Allow Liquid functions in parameters
How flabbergasted I was when I found out I can’t do the following:{% parameter view.name | replace: "sth", "st...
Where can i get LookML code for sample project that is pre loaded with Looker
I have a pre-loaded Sample project with connection to snowflake database. It is a simulated e-commerce store e...
How to utilize the value of a dashboard filter
I am building a dashboard where I want to compare numbers for one store versus the rest of the stores.I’ve see...
Subtotal not displaying correctly
Using an Apache Spark 3+ connection, I am trying to display simple subtotal results. Instead, the results are ...
Liquid HTML
I need help in creating a lookml dimension or measure to show the value for a YES or NO in map. I created a di...
Use dimension when creating measure with Case statement
I am trying to create a measure conditionally based on a dimension.My dimensions:dimension_group: date { hidde...
Comment out a block of code for AZERTY keyboard (or any non-English keyboard layout)
A lot of customers of Looker that use non-English keyboards (such as AZERTY) are unable to use keyboard shortc...
How to calculate multiple column values based on condition through measure
i have 4 column(ai_ov_s008,ai_ov_s009,ai_ov_s010,ai_ov_s011) but i need to add condition based on condition we...
