Explores Performance with Access Filters
Hola! everyone!We are implementing access filters in an explore, however when we apply them the consumption of...
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
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...
How to PoP
https://www.googlecloudcommunity.com/gc/Technical-Tips-Tricks/Methods-for-Period-Over-Period-PoP-Analysis-in-L...
How to make NULL (∅) values zero within a dynamic field.
Hello, I am new to looker. This code is for a tile in my dashboard and I want it to show '0', when there are n...
Looker Model
HI Team,can you suggest how to create multiple Look on same data source.I am thinking i need to create model a...
Using URLs and Query Parameters
Background on the URL In Looker pre-3.18, the url is a long list of parameters which includes the fields, filt...
Looker Studio: how to retrieve difference percentage value of column1 from maximum value of column2
Hi I have these values:Product | Sales | PriceA 1500 10B 5000 15C 250 25D 1700 30Leader sales product price is...
Bar chart missing data for first date bar
Hello,When trying to create a bar chart that shows averages by week I am receiving an empty bar even though th...
Filter Suggest Dimension from Liquid Parameter
Hi All,I am creating a dynamic comparison tool which allows users to select a granularity to compare a selecti...
Potential bug in dimension type: date filter due to obligatory TIMESTAMP conversion
when using a dimension of type date,dimension: utc_created_date {type: datesql: ${TABLE}.utc_created_date ;;de...
How can use matches(advanced) in looker to filer records last 30 days before the recent Monday
I'm working on a Looker dashboard, and I need to filter records based on a date dimension for the last 30 days...
SQL Runner Bug?
Hello,When using SQL Runner from the Develop Tab, if I run a query on a table as follows - SELECT TOP 10 * FRO...
Percentage change between two rows in a table
Hello! I have been trying for several days to make a table whose columns are some metrics such as impressions,...
Adding condition for Length to differentiate shorts and long video
Hi all, Im creating a Looker Dashboard. I would to create a conditional field where anything less than 1 minut...
Best Practices for Connecting Looker to Data Warehouse?
Did you all use data engineers to create the pipelines, or did you use a dedicated reverse ETL platform like C...
Using Liquid to dynamically adjust dimension definition of a derived table.
My situation is roughly as follows: I have a base view that contains daily pre-aggregated data with several at...
How to create a measure in LookML based on different views/explorers
I have created two views from a table with some implemented measures. It's something basic, illustrated as fol...
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 implement DatesYTD and DatesMTD using LookML
Implementation of DatesYTD, DatesMTD using LookML is simple, you just have to create another explore with sql_...
Run Inline Query API Call - Row Limit
Has anyone else noticed a change with the row limit for the API for run inline queries? We used to be able to ...
Lab "Answering Complex Questions Using Native Derived Tables" is broken - highly frustrating!
In the path BI and Analytics with Looker, the path: https://www.cloudskillsboost.google/paths/28/course_templa...
Am I able to use liquid filters to determine the value of the 'hidden: ' field ?
I would like to use something like this so that I’m able to hide dimensions based on the name of the view. dim...
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...
Creating a Confidence Interval based on data from a column
Hello Im trying to create a Confidence Interval but have no idea how to proceed. The CI is based on data from ...
Field Names on X-Axis (Line Chart)
Hi there! I'm returning to Looker after a few years for a project and I'm stuck on getting it to format this c...
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...
Dynamically adjusting connection based on user attributes
Hi! I'm working on a project to move our looker workloads from SQL Server to Snowflake. I'd like to be able to...
Select fields dynamically from a filter to use in a dashboard visual
I am trying to add fields (more than one) dynamically from a filter (which has a list of fields defined as a m...
Custom preset for a dashboard filter
I want to have a predefined collection of custom filter values for a dashboard. Something like configure defau...
connected model to another model
Is it possible to have one model which is connected to an other model ? I've my modelA which is connected to B...
