caculate cumulative total month by month every year since 2010
Hello,Please I want to create a dashboard calculate :the turnover month by month and the cumulative total of t...
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
Show Total regardless of any selections/filters
HI All,I need to show the Total Sales and the total sales should be shown always even when we filter using any...
Caching same query definition
The caching guide herehttps://docs.looker.com/data-modeling/learning-lookml/cachingstates that:"When a new que...
Custom Filter Request
The overall goal of the look I am going to create is to pull a list of accounts that have sent their first vis...
How to calculate Sum of averages for different level of detail?
We have information in a table with Sales by Invoice ID which is mapped to a Location and Area. Like below:Inv...
Snowflake and Looker Date Transfer Issue (snowflake time zone related) - about timestamp_ntz
there’s multiple data types available in snowflake - Timestamp_tz, timestamp_ntz.when we use dimension group f...
Any plans for a Prettier plugin?
Prettier would really help to achieve consistent formatting.
Dynamically choose the table using Date filter values without adding new filters/parameters.
Hello All,I have a derived table for monthly data and a dashboard based on that. But when users are trying to ...
Using parameters through nested derived tables
Hi, I have a base view (View 1) that is populated with a SQL statement. I used a parameter to update some valu...
SQL alias conversion in LookML
We have only one date column in database but two different references (alias in SQL) need to be made out of th...
Rank
Hi, i want to calculate the rank and i have the error as you see in the screenshot.Thank you
error derived table
Please, I want to create a derived table and bigquery as the database and i have this error :Query execution f...
Cache policy by date filter?
Is it possible to set Looker query caching based on the value of a date fiilter field?For example , most of ou...
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...
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....
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 ...
