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...
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 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...
Percent change from the last row
How do I calculate percent change from the last row of the result table?(For example, percent change from firs...
improve performance in looker derived table
I have a question about how to improve query performance in looker. I use derived table in looker to transform...
Reusable Table Calculations defined in LookML layer (new field type)
Lately I find myself wanting to use a measure of type: running_total in another measure. Things like that are ...
Sum Of Two different type values in Measure
Hi All,I am having problem with sum of two different type values .example : i have address_type like current a...
Am I able to move the filters to a different area?
So this is my first time using looker for a client and their style guide has a sidebar that has the filters on...
Elegant solution for Missing Values in numeric dimensions?
Hi all,I know there’s a few solutions for this, but they feel clunky and am wondering if I’m missing a more el...
Parameter to select set of metrics or do a calculation on multiple dimensions
I have a set of metrics that I want to visualise on a dashboard or exploreI would like to have some way of eit...
Use default value of a field
hi, i have this measure that depends on the field view_limit_quantity_daily is defined or not.If the field is ...
