how to escape a special character in my dynamic URL
Hello , I’m having an issue in which I have a parameter in my URL , for the most part it works well except one...
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
view with multiple table access which reside in different database
We have custom react application running on looker instance. Currently we are facing issue for solution we nee...
Configuring Looker for many single tenant data sources
We currently store client data in a single Looker database, and use a single connection to serve data to clien...
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...
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...
I want to create buckets based on a measure in Looker. Can you help me write it ?
I'm trying to run this, but I'm getting an error because I can't create a dimension based on a measure. Can yo...
LookML creating a dynamic label from multiple parameters
Hello, I am trying to create a dynamic label for a measure based off multiple parameters.The end user should b...
Limitations on number type and value_format
The Looker version we are currently on is 7.18.21Are there inherent limitations when using number and/or value...
reading a filter and setting a second filter dynamically based on the first filter
I have this code:view: salesPurchase_meas {extension: requiredfilter: currYearTmp {type: string suggest_dimens...
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...
Creating a dynamic URL that links to different dashboard
I’m trying to link two dashboards together because it seems like looker doesn’t support dashboards having sepa...
SQL Runner gives the graph I want. Looker Explore completely breaks it.
I'm trying to create a simple line chart with multiple lines, and none of the options in the Edit allow me to....
Conditionally format each cell based on a Table Calculation
Hello,Is it possible to conditionally format each cell in a table (with a Pivot Field), based on the output of...
BI Dashboard Migration from Tableau & SAP BOBJ to GCP Looker
Looking for a high level (or detailed) architecture diagram for BI Dashboard Migration from Tableau & SAP BOBJ...
Get/Sync Data from Looker to Excel
I have an Excel file which I need to populate with data from Looker. The excel file is sitting in the SharePoi...
Filtering Across Multiple Year-Partitioned Tables in Looker/BigQuery
We have BigQuery tables partitioned (sharded) by year (table_YYYY) into many tables having same schemas. The t...
Looker displaying Greek letter phi instead of a text string
The values in this field are all short (4 or 5 character) strings, but in the Explore Looker is displaying all...
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...
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...
