How to dynamically hide or select dimensions (columns) from visualization?
Hello,I would like to have a visualisation with multiple dimensions (say A, B, C & D) and related measures (sa...
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
Joining 2 tables without duplicating the same entries associated
I have 2 tables (see below): Whats the best way of joining them so I can have consolidated Customer ID list (1...
How to manage connection with daily log files?
New looker user. Normally I have a data person to rely on. I’ll have multiple models under 1 project. I have c...
Period over Period with weekday number
Hello, I would like to calculate the period over period with weekday number by letting the user choose the dat...
Can we login into looker through command prompt
Hi Team,Can anyone please share me the code/batch script to login into Looker through command prompt.If there ...
How to use views with multiple database tables in same model
@Jeff_Garcia , We are facing the same issue. We have created multiple views files using derived table from a m...
Joins within an explore work in development mode but not in "normal" explore mode
I have database with multiple tables and I am looking to join columns from the different tables together. I ha...
How does looker recognize Primary Keys when autogenerates code ?
Hello everyone,My question is: How does looker recognize Primary Keys when autogenerates code (after having cr...
drill_fields Primary Key
Hello everyone!I’ve seen that the autogenerating LookML for a new project creates in a certain view this comma...
How do I stop Looker from modifying queries?!?!
Hi. I have Google BigQuery queries that run perfectly fine in the sql runner, but will not run in production b...
Concatenate strings in liquid if statement for label
I am trying to concatenate strings inside a liquid if statement as part of the label argument of a dimension b...
How to add hours to my timeframe field?
I have a dimension group like this--dimension_group: timestamp{ type: time description: "day-month-year time o...
Moving Unnest Statements to the end of the query
When we use unnest query to flatten arrays in looker, by default the joins are added in the same order of the ...
how to hide base dashboard being extended in a new model from LookML Dashboards?
I am extending an imported projects dashboard. I created a new model that references the base dashboard and th...
add dimensions as they appear in a JSON column
We’ve got a JSON column with varied and often-changing keys. I want each of those keys to be a dimension.What ...
How to define a dimension with custom values on LookML?
I need to create a dimension with custom values such as ‘Demand’, ‘Visits Last Year’, ‘Avg Selling Price’ for ...
how to copy a production project to create a hub for hub and spoke
I want to convert a production project into a hub for hub and spoke.We currently serve multiple clients from o...
convert my timestamp dimension group from utc to gmt?
I have a dimension group like this--dimension_group: timestamp{ type: time description: "day-month-year time o...
How do we change an integer to string
Would like to change my sql in lookml from an integer originally to a string. dimension: nest { type: number s...
query date filters
So we have a lot of end users that like to run queries that have no date filters or use ‘is_any_time’ on the d...
Modelling Expansion Revenue SaaS
Hi everybody.I am currently struggling with defining and creating a specific metric for a SaaS business which ...
Project dupllication
Hello ! Is possible to duplicate projects in order to have a backup ?Thank you!Edit: Sorry for the misspell in...
Does a Image come back
I have a list of products , some will have images on a website , i can pull those in to Looker , what i need t...
Currency conversion
Hi, We are having multiple currency revenue in a table. I want to convert them all in one currency USD. How ca...
how to make case dimensions out of a column?
Does someone know how I can use this type of sql in Looker?Select , count(case when tickets= 'A' then id end) ...
How to add multiple values in multiple filters within the same field inside a view?
wanted to add something like this but not able to find a correct syntax--measure: total_revenue { type: sum sq...
Change join type dynamically with filters or parameters?
Hello everyone, I have a bit of a particular situation and was hoping for a workaround. Our Purchase table is ...
Check if an array is empty
I have a table user_list_data with two columns, user_id and portfolio. For instance:user_id | portfolio1 | {1,...
Imablanced Aggregation
Hello, I have 2 tables.SalesDate Product Size Number Sold 1/1/2021 T-shirt L 500 1/1/2021 T-shirt S 400 1/1/20...
Small UX Bug - hiding column with list of files
Lack of z-index makes this button hard to click:
