Dimension and measures
I am new to looker and can someone tell me the which is the right SQL while creating a measure or dimension. I...
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
Get the latest date of whole dataset
Hello,I have a date column and I want to get the latest date of this column. This table is updating every week...
Create a custom filter based on new options
Hi there,In tableau you can create sets from values, and then use those sets to define a new list of options f...
what if we use the wrong relationship in join lookml
https://community.looker.com/technical-tips-tricks-1021/how-does-an-incorrect-relationship-affect-queries-2368...
what happens if we use one to many relationship instead of many to many
Since many to many and one to many will both trigger symmetric aggregation, so what will happen if we use many...
How do I remove the GROUP BY clause for an explore/view with non-aggregate measures?
I have a pre-computed metric table that has a small set of dimensions and non-aggregate measures. How do I mod...
Create custom measure that shows future expected sales
Hi, I am very new to Looker and was wondering if someone could point me in the right direction.I need to creat...
forgot to pull from production
I know that the first thing before developing is to pull from production. In Dev mode, I forgot to pull from p...
Expand Looker Dashboard Size
I have a dashboard that in the past if I created my tiles and expanded them and lined them up it would automat...
How can you dynamically hide fields from table visualization depending on customer request.
We have a scheduled legacy report for conversion to Looker that requires display of required and optional fiel...
Hiding the drill-down option
Hey all,for manually calculated percentages (for example measure a / measure b) the drill-down is not correct....
Group and Count Results by Range?
Hi, I’ve got a results set that is a table calculated list of percentages. I’d like to group them by a range a...
How to find differences week over week?
Hi! Apologies if this has been asked before - I’m having a hard time figuring out even what question to ask.I’...
Can a SQL Runner query make changes to a database?
Hi All, just new to Looker does SQL Runner access the database directly and if yes can it make changes to a ta...
Test connect: Cannot connect: connection refused: Java::OrgPostgresqlUtil::PSQLException: The connection attempt failed.
While logging in to postgres db from looker dashboard with looker as a user, i am getting the error as “Test c...
Look for query run time
HiI’m after a simple Look on the meta data to show the monthly average query run time across the whole instanc...
Create a set of custom filter options not in list of values
Hi there,In tableau you can create sets from values, and then use those sets to define a new list of options f...
filter-only-field on multiple dimensions
hello everyone, I have the need to apply a filter to a dashboard but it must be hidden, this means no user inp...
Filtered measures using SQL filter expressions
The problem starts when looker suggests that you can use sql as a filter expression inside a measure, but I ha...
Primary key
Hi,I am having trouble with joining a NDT back into the source view.I created a primary key in a refined view ...
LookML order month name by chronologically
For the dimension time frame, I want to sort the month name by chronologically. how to edit the code below? di...
'To-Day' Filters While Comparing PoP
I am trying to create a dashboard where the user can select a date, and the single-value tiles would then show...
custom filters for two or more tags
Hi, My name is Alex,I am making a custom filter that I hope will return the number of people that have two tag...
PDTs in Looker vs DBT Best Approaches
Hi, I’m working on a project that has tech stack - Snowflake - DBT - Looker setup already. Snowflake is the ma...
Machine Learning
Machine learning is a subfield of artificial intelligence, which is broadly defined as the capability of a mac...
SQL error in derived table
Hi,I am connecting to an Athena database. I have created an array which simply lists the dates from 2000 to 20...
Assign bar colors based on attribute value
Hello. I am looking to assign the color of bars based on attribute values, within the LookML. I know this can ...
Create dynamic time frame for dimension group
I want to use parameter to allow users to change timeframes on the dashboard so they can choose between rollin...
Unexpected ELSE in parameter
I have the following parameter code block: set: absolute { fields: [ 10th_percentile, 25th_percentile, 50th_pe...
Calculations on whole dashboard using LookML
I would like to create a parameter in LookML which normalises all the metrics on a dashboard when selected. So...
