How to create case-when dimension for a measure?
I have a wild scenario where I need to create dimension with case-when but the field that I am comparing insid...
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 filter a measure with HLL Sketch fields
Some customers create fields in BigQuery with HLL (HyperLogLog functions), which create a sketch of a count or...
Join explosion when trying to compute metrics from two different views
We are trying to compute measures that need to use fields from different views/tables. For example, we have th...
Abnormal Forecast Results
Morning!When adding a prediction/forecasting feature into my looker graph, the results are impossible to justi...
Complex issue with the way Looker calculates totals
Looker offers to calculate the total in addition to the details in an Explore: This has always been a bit tric...
Time frame dimension is not working in Dev
Hello Looker Team,Context:We have built SQL-based derived views, where we created a time frame dimension. This...
Exploring Lookml Connector in Looker Studio Pro
Hi,I am trying to create a Looker Studio report using Lookml Connector and wanted to check if the following sc...
Creating couple columns from a single nested field
Hi,We store event log properties in nested fields, as shown below: dimension: message_number { type: number vi...
Looker Google Map Drill Down table
Hello! When drilling down into Looker Google Maps, the drill down would take the user directly to a table, but...
Use Looker System Activity data in our own LookML models
I am wanting to use the Looker System Activity models in our own model in LookML in order to combine it with o...
can we send the API key in header using data action
we are sending the feedback from looker dashboard by using the data action and putting cloud function url that...
group a field to get maximum value
i need the year and Data accordingly which has highest Global Sales it should only group by year and give the ...
Passing Looker User Attributes in Query Context
By default, Looker passes user_id and history_slug in the query context.I wanted to check if there’s a way to ...
Persist Data and Auto-Refresh
I have some slow running models and have found adding `persist_for` for 1440 minutes and scheduling the dashbo...
Fixed Calculations and Other Level of Detail Functions
Hello fellow Lookers,I am relatively new to using LookML and I am coming from a long time working with Tableau...
Error with Cell Visualization Colors
I dont know why but when I set a table and able the cell visuzalization for a field, the pallete of colors tha...
LookML Model
Hi everyone, I have a question regarding the creation of a model in LookML. Specifically, I’m trying to build ...
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__...
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 avoid unnecessary join
Hi, I have an explore in which I join a view, say view1 to another view, say view2 like so:explore: view1{ joi...
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...
