templated filters and derived tables
view: closed_loans { derived_table: { sql: with closed_loan_data as ( select row_number() over (order by coale...
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
Displaying Latitude and Longitude values in Looker studio
What is the best way to represent Geo data in visualization. I have around 1 million rows Latitude and Longitu...
Inaccessible view error when joining a view with a "from" parameter
The problem is that I have a measure that is defined in a refined view that then is joined into an explore. Th...
I want to calculate top reduced business compared with week/month
Hi team,I want to calculate the change revenue week/month and list all businesses with big change about sales
Test
Test- please ignore
How to ret percentage per value
Hi everyone. Could you please help me with percentage calculation in LookML? I need to count percentage of yes...
Is this a bug on Visualization ?
In Looker while i created a report adding Dim & Measures , the graph stack size are wrong , if you see y axis ...
Multiple selection dropdown menu with a SQL DISTINCT UNION of values
Hello,I’d like to create a dropdown filter of approximately 70 values, the values are from an SQL query of the...
LookML filter dependent on another?
Hello, I am trying to create two filters on a dashboard. The setup is this. We have multiple teams and multipl...
Red dots in front of my LookML
I tried to find what these dots mean but couldn’t find it. The code seem to work, but maybe is there some prob...
Why does HTML link not work in dashboard but works in explore/look?
Hi, I’m trying to create drill down analysis using HTML link and parameters. If I click on country and pass th...
Compare Current Day with the last 7 days average
HiI’m trying to build a look/table which shows a measure for current day value, as well as an average of the l...
LookML cannot parse Liquid
Hi Looker team,Database Dialect: BigQueryContext:We build the SQL-based derived tables.In the SQL, there are s...
LookML Dashboard: Restricting values in dropdown filter
Hello I am creating a LookML dashboard and currently I have a field_filter which allows the user to choose fro...
sql_query SDK Encoding Error error.SDKError(response.value.decode(encoding=encoding))
When calling sql_query method, I receive an SDKError for encoding with the below stack traceSDKError Traceback...
Updates to Looker Blocks
Hello,My question is a basic one but I can’t seem to find any good information on it.If a Block is updated to ...
Count non-distinct values in a dimension
Hi,How do I go about count non-distinct values in looker explore for one dimension.I can write this in SQL but...
Hiding some but not all fields in a dimension group
Hi I have a date dimension group that has the following structure: dimension_group: date_created { type: time ...
Error: Dimension containing a link joined into a explore causing blank screen when used
When I try to bring a dimension into a Look my page just goes blank. I have isolated the cause but am unsure o...
WEEKDAY function not found
Hello Folks,I want to return the current date as an index. So, I was using the weekday function WEEKDAY(NOW( )...
Connecting looker to views SQL server
Can we not connect to views created in SQL server?
Identifying Looker content impacted by LookML changes
Is it possible to find the impact of our lookml changes on other dashboards or which will get affected because...
How to implement private embedding in looker ? also not sure where we can add iframe
How to implement private embedding in looker ? also not sure where we can add iframe
Word Frequency Analysis / Word Clouds: Analytical Pattern
The Objective: Looking to analyze text fields? Want to understand top or trending keywords? Some common use ca...
Localization for title_text in Dashboard
We are localizing our lookml dashboardsWe have title_text in dashboard configuration as follows- name: 'Quarte...
FIiter an explore before join
Hello, so I have two problems.PROBLEM1So, I have this explore and join in a model. I want to join some values ...
Split aggregation for a filter in LookML
Is it possble to use something similiar to string_split in LookML to get unique value for my filters?I have a ...
Filter Period-over-Period Analysis based on customer cohorts
Hey Guys, I build a PoP-Analysis for an orders dataset. I want to add the following logic now: If I am choosin...
Creating a measure for same day last month
Hi folks, I’m looking to build a measure to sum a number e.g. outstanding balance for the same day last month....
Quick Starts: Limit of 10 per explore?
I’ve been adding quick starts to an explore using the query objects. It appears the UI doesn’t support adding ...
