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 ...
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
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...
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...
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 ...
Using user attributes with week start day
I have two clients working in explores on the same model who need two different settings for week_start_day. D...
What max cache can we set in Mbs/Tbs ?
Hi everyone,Whos know max cache in looker which I can apply? Because I found only default value (2000mbs.) --o...
Looker Filter Expressions
Hi Community!What are the differences between measures leveraging Looker Filter Expressions and When Case Stat...
Explore Doesn't Show up When Creating a Project, and I can't create an Explore in the Model File
This should be basic, but I can’t figure out what’s going wrong. When I create the project from a single table...
Case Statement
New to Looker and need some help. I have the following query which works fine. What I’m trying to do is add a ...
How to set a relative date as the default date for a date filter parameter?
How to set default value for a date filter parameter which is like ‘3 months before todays date’ and also give...
Conditionally multiplying a numeric filter
We have an implementation of Period-over-Period analysis that we’ve paired with a date granularity filter so t...
How Join with two explores?
HiI built one explore :I want built customers explore and add these tables with left join to the explore but I...
