How to convert string to integer or number in custom measure or dimension
While I was trying to generate a dashboard on chronicle, Can't use sum as ${events__additional__fields.value__...
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
Filter suggestions not working when using a derived table with templated parameter
Hello,When using a derived table that contains liquid expressions in my .view file, I discovered that the filt...
Work with Dates in Looker Without Unnecessary SQL Date Conversions
How can I configure Looker to handle date fields without unnecessary SQL conversions, while still enabling eff...
Tableau to looker Migration
Hi there, We are planning to migrate to Looker from Tableau.Instead of creating model from scratch, I am curio...
Looker Filter Suggestions not passing Parameter into Query
We’ve just started experiencing an error on the Filter Suggestions call when trying to pull up suggestions in ...
In LookML, Does the tags parameter guarantee the order or sequence of text
Hey Team,I have a use case where I need to add metadata information to my Explore. To achieve this, I plan to ...
Date Label Issue
Hi Community,I am new to looker. I have mapped in a new model and in the view there are a number of Date field...
How to display one value in a filter's dropdown list while filtering on a different value
Suppose I have the following 2 dimensions: dimension: department_display_name { type: string sql: ${TABLE}."de...
Incremental PDT build "skipped due to error in required child"
I have had ongoing issues with incremental PDTs failing to build. I made changes to the sql trigger for my PDT...
How to Stop Automatic Date Conversion in Looker Filters
I have date dimension, and I have a filter based on date to get data earlier than certain date. However, I not...
Using Maximum Date in Filter to Filter Results
Hi I posted this question here: https://www.googlecloudcommunity.com/gc/Modeling/Templated-filter-to-get-the-m...
How to Implement Separate Month-Specific and Cumulative Sales Metrics in Looker
Hi!I need help with modeling a visualization in Looker and LookML.I'm recreating a table chart from another to...
Templated filter to get the max date in Looker Look ML
Dear All,Would like to hear your thoughts on one of the requirements we're attempting to do in Looker.Sales an...
Parameter to display round number or decimal
Hello,I'd like to add a filter/parameter in a dashboard that controls whether the displayed dashboard numbers ...
Looker formula
I have merged 2 mysql data tables in looker. Now I need to create a calculated field in the second table that ...
Using "date_start" and "date_end" values of a filter in liquid if statement
Hello, everyone!I’m using templated filters with filter of type “date”. At the same time I need to display the...
How to use liquid variables date dimension and forecasting
Hello! I'm using this way to choose data aggregation in my current Looker solution: dimension_group: created {...
Filter suggestions and conditionally_filter with unless
Our Explores have a conditionally_filter where by default it will only show values with a createdDate of 30 da...
Merge Queries and Content Validator
Sometimes it is necessary to change the name or a location of an explore and usually Content Validator is powe...
Add image using markdown tile to dashboard
How to add an Image (that is not hosted on any website) and use it in dashboard of Looker.
Link a Dashboard to another one passing dashboard filter values to linked dashboard
Hey Team, I was exploring the Looker button and markdown options to link two dashboards together. Yes, I was a...
How to load a database with negative hours in Looker?
Hello, all!I'm trying to use a variable that contains the total hours of work people accumulated in a period -...
case statement for whole numbers
I'm looking to create a case statement that will have two bucketsWhole numbers and numbers with values after d...
Date Dimension with Global Holiday Calendar
Hi,I need data about all holidays and days off in world.I'd like to get example script for all tables
We have a table look and we need to have action implementation on that , need help here
We have a table look and we have around 13 columns in that table look and on that last 3 columns client will c...
Temporal Series Graphs - How to set a custom start date on the X-asis
Hello,I need assistance with a time series graph in Looker Studio. I’m trying to compare five different sales ...
creating a button for clear cache and refresh a dashboard to see the updated changes
Can we create a button in looker dashboard so that we can click on that and that will do the clear cache and r...
How to implement DatesYTD and DatesMTD using LookML
Implementation of DatesYTD, DatesMTD using LookML is simple, you just have to create another explore with sql_...
Avoid duplication of SQL logic of different measurements
Hello,In my project we have a lot of measurements which tend to share the same common SQL logic applied for a ...
Computing correlation in LookML as a Custom field
I am trying to implement correlation between two fields in Looker. It is indeed possible as a Table calculatio...
