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...
Forum Posts
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 ...
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...
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...
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...
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 ...
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? ...
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...
Qualify in LookML - Workaround
Hello! Attempting to use the “QUALIFY” sql statement (working with Snowflake), I found pretty tricky but elega...
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...
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 ...