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...
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
[Analytic Block] Supercharge your KPI tracking for multi-dimensional dataset: Looker and BQML
Hi there @Looker Community! We have been recently working on the topic of KPI tracking and implementation of t...
Conditional formatting using value_format
The content of this article has been updated and migrated to a Looker Help Center article. But, the informatio...
No Map Layer named LookML Warning
Hi, I have defined a map_layer_name following all these stepsMy map works perfectly in development mode and I ...
Changing a Model's Connection Based On Instance Name
Is it possible for a model to use a different connection string based on the name of the instance it is on?We ...
Manifest Lock Error
Has anyone come across this type of error when trying to Update Dependencies?And how did you solve it please?I...
Display string message if a value is null
Hi hi! When a calculation result is null, what’s the best way to display a text (something like “No Data Avail...
Hub and Spoke: extending dashboards
Is there a way to extend the elements/tiles in a dashboard? For this doc Extending a LookML Dashboard, it only...
Adding Links to Table Calculation
I have created a single value visual using a table calculation. I want to add Drill fields and Link parameter ...
Using a Filter value to execute only part of Derived Query
I have the following derived query:derived_table: { sql:select * from this_yearunion allselect * from last_yea...
Using IF ELSE with 2 parameter
Need help! I’ve been trying different IF ELSE logic combination to achieve the results. here’s my sample query...
user_attributes URL parameter
Is there a way to access the user_attributes parameter that is coming in an embed URL? I need to capture this ...
Rename Field name in Explore
Hi,I want to Rename Field names (of a Table/View pulled in Looker from Google Big Query) in Explore Page. Any ...
Trouble creating pivot table without aggregate function
I have a view with two dimensions (serial_number and condition) and a measure (test_metric) of type: number. T...
How to place one measure above another w.r.t dimension in table chart
Hi team,I have two dimensions Year and Quarter Number with two measures This year sales and Last year sales.TY...
concat -> The type of field is not currently supported
hi all,i’m trying to build a link by combining info from a few different fields. one field is stored in a diff...
There is a way to avoid filtering at the end of the query?
Hi guysI’m starting to use Looker, I want to create a model to be use for multiples user on his dashboards. Wh...
Missing ${TABLE} prefix for some sql field of dimensions when using "Generate view from table"
Hi there,We use Bigquery and we have tables with RECORD (repeated and nullable).Sometimes for a table we have ...
How does cache work?
I’m trying to understand datagroups/cache Say for example the max_cache_age is set to one hour and looker keep...
LookML model file doesn't exist yet [message in Project]
LookML model file doesn't exist yet [message in Project]Please note I have create LookML model using API creat...
Column totals shows undefined for string columns
How to exclude String column from column totals ? By default it shows undefined when column totals enabled. Is...
the visual i create in SQL runner isn't working in Explore
I’m running a SQL query to generate a visualization but when I go to try and recreate the visualization in the...
GSP361 challenge lab
Hi,Did anyone completed first task in GSP361 challenge lab. total_gross_margin field is throwing error saying ...
Build LookML Objects in Looker: Challenge Lab GSP361
Hi there,Has anyone completed “Build LookML Objects in Looker: Challenge Lab GSP361” I asked for help on the s...
Looker Aggregate query contained the following measures we cannot roll up
Hello Everyone,I am rather new to Looker and am trying to setup an Aggregate Awareness to speed up some of our...
Subtracting Two Measures
I am simply trying to subtract two measures: Count of X - Count of Y? This is done easily with a table calcula...
How to group by using only selected columns in looker?
I have a base table with me on which I am applying the aggregation over the aggregation. How can I make it dyn...
Emoji Rendering In Dashboards
I’ve set up a dashboard so that our customers which reach 100% of a metric show up with a green box emoji, tho...
CloudxLab is hiring for the role of Looker Subject Matter Expert- Part time (can be done with your existing job)
Hi amazing people, We are looking for a subject matter expert to train learners around the globe, on Looker vi...
How to create a 'days prior to event date' dimension, to be used in place of actual calendar days?
I have a scenario where I want to compare the a the trend among multiple customer/clients leading up to a cert...
