Can I use a where clause while defining dimension?
I’m trying to define a dimension where I need to get the register id where the MEAS_CDE column is SLS or SLS_L...
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
Converting SQL queries and stored procedures into LookML coding
Please help me understand converting some SQL query (see demo example below) into equivalent LookML coding; ex...
Conditional liquid filter - string matching not exact
Hi - I want the user to be able to input a value in a filter in a dashboard and then apply that value within t...
LookML Data Tests: Recommendations and Best Practices
tl;dr: Do you use data tests? If so, what are some practices that you like to employ, whether they’re similar ...
Derived table - To use filters created in the Case When Clause of the Derived table create Syntax
Hi,I have created a derived sql view with some filters in it say:“filter: abdc { type: date)”Now I want to use...
Concatenate Dimensions
Hi I am a newbie to looker. How do i create a custom dimension by concatenating three dimensions that we curre...
How to create a custom filter in a look that uses an OR statement
I’m trying to create a report that shows all loans where they had their promotional program end yesterday or t...
Using dimension that contains Liquid in Custom Dimension
I have a dimension in the view that contains some Liquid. It allows me to parameterise the selection of curren...
Rendering HTML and Escape characters inside of text fields
I was wondering if it’s possible to parse HTML and new line characters contained within text fields returned b...
Total Label Stacked Percentage chart
Hi, If I start with a stacked chart with a total value label, when I change it to a stacked percentage chart, ...
Grouping
I have a report that list students employed and their employers. I would like to group by the employer and the...
Create measure from dimension_group
Is it possible to create a measure based off a dimension_group (e.g. duration)?e.g.dimension_group: MyDuration...
Left Outer Join Help
I have put together what seems to be a fairly simple left outer join query but it is acting like a full query....
Merge Queries and Content Validator
Sometimes it is necessary to change the name or a location of an explore and usually Content Validator is powe...
Multiple values comparison with arrow
Hello, How I can show arrows in the multiple values comparison viz?I have table like this, for the “percent ch...
Append a Label to all Values
I would like to try and replicate some of the behavior of the duration dimension_group. Such as, the resulting...
dimension_group, type time, not sorted well in explore
I am using a dimension_group type time and a timeframe to get several dataformats in my explore.F.e. timeframe...
Access Filter with manipulated User Attribute
Hi there,Is there a way to manipulate a string from a user_attribute to use with an access filter?I currently ...
New Project - Model wont recognize views
In a new project my Model wont recongize view name?? For this test case I am using the Looker Hub and not GitH...
Add filters from one view to another view
I am pretty new to looker. Please check if you can help me on the belowProblem Statement:I got one main table ...
default time dimension group
Hi,When I create view from table, it is automatically make the dates as dimension group with these options: ra...
PDT .publish_as_db_view: yes
Hi All,I want to be able to query my pdt through a view since the PDT name changes every time with a new rebui...
Aggregate awareness - filter values
Do you know of a way to include multiple values in the filter of an aggregate awareness table, and get looker ...
Using week based date filters with Spark connection causes database errors
We recently upgraded our back end databases to Apache Spark 2.0 via a Delta Lake instance and we noticed some ...
Tabs, New Lines, etc. in String Dimension
I have noticed that string formatting is stripped away in Looker. Example, if I have a string Dimension and th...
Native Derived Table Filter
Hello all,How would I apply a NULL filter on a Native Derived Table using an explore source? I understand how ...
Filters & Liquid Parameters for Derived Tables
view: global_dashboard_poc { # Or, you could make this view a derived table, like this: derived_table: { sql: ...
Link not passing query parameter
I currently have a view that has a link that should pass an ID in as a query parameter to the next dashboard. ...
Net Sales in Stacked Bar Chart by Cohort
I am struggling for a while now to figure out how can I create a LookML code to get the graph as shown in the ...
