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 ...
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
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...
How can I use special character in Liquid Filter?
SITUATIONI have parameter and filter and this is the LOOKML:parameter: attr { type: unquoted description: "Nam...
"Error: view not found" when others access my dashboard
I created a personal dashboard and then copied the LookML into my project and deployed to production. I could,...
Clause in LEFT JOIN rather than WHERE
Following a Community post from 2015, this can be done by using a filter (not dimension) and then ‘passing it’...
How to: Project Administration (without LookML development)
Authored for Looker version 22.8 in June 2022Imagine you have joined a new company as a Looker admin. Your Loo...
Liquid date filter
Hello everyone,I am trying to build a chart that shows two values : the number of views of a publisher’s video...
quick custom topojson shape on a map
Hi, I struggled to find an easy explanation on how I can easily display my own shapes on a map and then match ...
