Fixed Calculations and Other Level of Detail Functions
Hello fellow Lookers,I am relatively new to using LookML and I am coming from a long time working with Tableau...
Forum Posts
How to avoid unnecessary join
Hi, I have an explore in which I join a view, say view1 to another view, say view2 like so:explore: view1{ joi...
Testing LookML and Looks
I love that Looker has the ability to perform #testing on the data within the #lookML. Great details documente...
Link not passing dashboard filter value
I’m trying generate a list of dashboard names that link to the referenced dashboard. In order to accomplish th...
Dynamically apply calculation to all table values
Hi everyone!Little stuck on on something…Image that there is a table with one dimension with a bunch of measur...
How to calculate YTD,MTD ,LYYTD and Cumulative calculations in Looker?
Hi All,Could you please let me know How to calculate” YTD,MTD ,LYYTD and Cumulative “calculations in Looker?Pl...
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 return column A value based on largest column B value
I am trying to create a calculated field/measure that returns the string value in column C, based on the large...
Date Parameter Default Setting to yesterday
Hi there,I’m quite new to Looker (a few weeks now) and got stuck at a Parameter default topic.The parameter is...
order_by_field function is not working
order_by_field function is not working when pivoting a dimension and when using new_lookml_runtime: yes. A ver...
How do I give a user access to a specific explore?
Hi,So I am a LookML developer and Im not that good yet with access. We have a lot of different explores which ...
Configuring a dynamic explore_source in Native Derived Table?
I’m trying to make a generic view to allow “Top N” rankings on pivotted Looks (eg. line-chart timeseries). I’v...
Crazy average value on measure
Looker is generating a crazy average SQL and I don't understand why. In my view, I have a number field which r...
LookML concatenation with space in between fields
Trying to concatenate dimensions and separate them with a space or dash but when I add in the character the ne...
Advanced Date Filtering
Hello y’allI am currently trying to find my way around the advanced date filtering, and struggling to find a s...
order_by_field descending?
Is there a way to use the order_by_field parameter in my dimension, but specify that it should sort Descending...
liquid with drill_fields
Hi, Im trying to achieve something along the lines of the following. I want to display a different set of deta...
Download PDF reports limits the rows
When downloading a report as .pdf, we select download and it does download only what’s visible in the UI. it d...
Required Dimension in Explore
I’m building an explore that will be used for a very specific purpose, and because of this there are certain d...
Is it possible to rename fields when joining a view to a explore?
I would want to rename a field when doing the join of a view into a explore, to have a more descriptive name f...
Currency Conversion Parameter and Formatting
It’s common to want to switch between currencies in Looker. This is usually achieved by having your results/ta...
How to convert time duration(Ex.. like 1d 5h 12m 25s from 55678900 seconds )
Hi,i am a looker developer i need to create one look.i have a dimension called duration,dimension: duration{ty...
Filter OR condition / additive result / full-custom WHERE clause
I’m looking for a way to have my Explore’s generated SQL include a WHERE clause that includes OR logic. This w...
How to copy views from one project to another project in Looker
I have some views in project 1 (will be deprecated) and need to copy them to project 2. Project 1 and Project ...
Charts like Stock Market
Hi,I am trying to create a chart that looks similar to a stock market chart , that gives you the value of a st...
value_format to show Duration in Days Hours Minutes Seconds doesn't work
I am trying to create a visualization to show the duration as dd days hh hours mm minutes ss seconds format. S...
Limitations on number type and value_format
The Looker version we are currently on is 7.18.21Are there inherent limitations when using number and/or value...
Get/Sync Data from Looker to Excel
I have an Excel file which I need to populate with data from Looker. The excel file is sitting in the SharePoi...
Liquid - Number format
Hey everyone, nice to meet you all.I have a measure, which has several ifs, as it follows:measure: someMeasure...
Qualify in LookML
Hi All,I am wondering if there any way to filter on row_number window function in Looker or using LookML. I am...