Use different locales for each timeframes
Greetings!I am currently applying a locale to my dashboards. Everything is working fine, except for that.I hav...
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
Replace 0 with null on column
Hello,I am trying to change some zero values with null because they show on the graph and they look ugly. I ha...
Custom filters/parameters: Select a complete full month
Hello,I have created a dashboard where I want the users to be able to compare period over period, specifically...
Downloading information from LookML
Hey all! I would like to know if there is any python script that allows me to connect to Looker API and downlo...
DAU and MAU as measures for a "not" aggregated table
Hi, I am new to looker so please bear with me. I am trying to make the DAU and MAU for my company. I tired thi...
value_format result is wrong
Looker Version:## Contextvalue_format definition: 201 seconds to mm:ss should be 03:21.3 * 60 + 21 = 201;But t...
Given a date dimension, how to calculate `business day into month` of this date dim?
I have a date dimension in a view, I can drill it down to timeframes:[raw,date,day,week,month,quarter,year,]I ...
Adding measure based on date
Hi all,I am trying to create an aggregation based on the date of a measure I have which should not include the...
possible to hide table if empty?
is it possible to only show a table in a dashboard if it has data?
"xxx_DB"."XXXX"."OPPORTUNITY" table
Seeing "xxx_DB"."XXXX"."OPPORTUNITY" as a table name used to perform a join. Can someone explain what the quot...
How to check in an element is in a list by creating a custom dimension?
I want to write something in a custom dimension to check if :for a id, there are many rules that apply to this...
Filter literal date format
Currently ‘is on this day’ shows Jul 20, 2022 and 07/20/2022.How do I change this to 20 Jul, 2022 and 20/07/20...
date_end liquid variable?
This gives you the ending date in a date filter, and is very useful.If the user selects ‘is in the past 1 comp...
Extending explore with common calculations
I have an explore that I’d like to use solely as an extension in models. That is, there are dimensions and mea...
Date parameter value in results table?
Is it possible to get date parameter values into the results table? Say, a user selects a start date and end d...
How to get max date for use in CASE WHEN statement in LookML
I have a dimension ${date} which references the DATE column in my table I have another measure ${revenue} that...
Looker Developer Certification
Are there any plans for Looker/Google to bring back the Looker Developer Certification? If so, what is the tim...
SQL query for merged results
Hey! Is there any way to see the sql query for merged results like it is seen for regular queries?If not then ...
Customize Looker Dashboard Filters
My team and I are trying to customize a filter for a dashboard so that a user can type an input into the filte...
How to apply a conditional formatting using the main filter on top of a dashboard?
I want to apply a conditional formatting in looker based on a Measure value using a filter setting of the main...
Like-for-Like comparison
Hi all, on our Dashboards we do have a lot of Looks that show our KPIs and the comparison to last year. Howeve...
Connect Tableau to Looker database
I use Looker to manage my data stored in Amazon RedShift database. Though Looker has dash-boarding capabilitie...
Share custom dimension between different views to avoid rewrite
My use case is the following:I have many views with a “country” dimension that is populated with ISO-8601 coun...
Filter a drill through dimension by a measure
I currently have a drill through dimension that is returning too many detailed records when you click on the d...
Looker Action to hit Http server in LookML
How can we specify authorization header for Looker actions?Following is my LookMLdimension: report_name { acti...
How to automate commit of code architecture to an Azure DevOps Repository?
I am working on an automation, that will create repositories and pipelines based on standards and requirements...
Only find filters that have been used
Hi,I have a dashboard with lots of filters and I’m trying to create a user activity dashboard where I could ch...
User defined parameter default value
Hey guys, I am trying to find a solution for my problem: We have a parameter used in different explores: view:...
Date Filter CASTING
Very new to Looker. What determines the internals behind how Looker converts a filter to a datetime? For examp...
date_start and date_end
I’ve seen examples of using date_start and date_end with a date filter. Can you also use them with a date dime...
