Using LIKE operator for parameter in derived table
It's similar to this thread https://www.googlecloudcommunity.com/gc/Modeling/Using-LIKE-operator-and-wildcards...
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 create a dynamic filter based on grouping
I have a table like thisCustomerproducttotalabca2abca3abcb4efga1efgb2lets say, I put a filter to show me anyth...
How to Align Multiple Metrics with Different Time Dimensions in Looker?
Hi ,I need help defining a time dimension for a Looker chart where different metrics have different date fiel...
Unlock Data Insights with Looker's Semantic Model
Unlock Data Insights with Looker's Semantic Model Are you new to Looker and eager to harness the power of data...
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...
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...
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...
How to force Looker do not show subtotals for some specific dimensions
Here you can show if I toggle on Subtotals (pic 1), my looker chart shows subtotals for each level of dimensio...
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...
Filter on current week and the previous week using templated filters in LookML
I am trying to create templated filters in LookML to filter the current week and the previous week of data. Th...
Looker Dynamic Filters
I’m building a Looker dashboard where I want certain filters to appear dynamically based on the selection of a...
order_by_field descending?
Is there a way to use the order_by_field parameter in my dimension, but specify that it should sort Descending...
Why are explores getting auto created in my model?
Hi Community!I have a View A defined in a view.lkml file, and I have defined an Explore A using View A in a mo...
Dynamic Filter in LookML
I am trying to create a dynamic filter to use in a dashboard. Ideally when the user selects a value from the F...
Facing weird puma cough error while opening the drildown in looker table look
I have a table look which has around 15 columns and for two of the measures I have put drilldown to show the s...
how to convert number to string in custom dimension?
I used the to_string function here. But it doesn’t seem to work. And if I don’t convert it to string, the func...
How to remove Explore name prefix from dimension/measure names in Looker Studio Explorer?
Hello everyone,I'm working with LookML and Looker Studio Explorer, but I'm running into an issue where my dime...
Dynamic Connection Switching in Looker for Embedded Dashboards
Hi,I have embedded a Looker dashboard using SSO embedding within a product that serves multiple customers. Eac...
Dynamically changing looker connection inside model file
I have been trying to dynamically change the looker connection using user attributes. Here the database connec...
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...
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...
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...
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...
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...
LookML Model
Hi everyone, I have a question regarding the creation of a model in LookML. Specifically, I’m trying to build ...
