Writing data test and expecting null values
How do we write data tests to ensure the return are always null? I have some filter conditions for a certain s...
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
Date Comparison Block
Date Comparison Block What is this block? This block allows for comparisons from one date period to another, o...
Day of week in custom dimension?
Hi, is it possible to extract day of week or day of week index in custom dimensions or table calculations? I d...
purchase & build looker
How to purchase & build looker Visualization for a company, Please guide step by step
stddev_pop producing incorrect results?
Hi,I’m trying to return the standard deviation of a dimensionalized measure in an NDT but am getting incorrect...
Complex issue with the way Looker calculates totals
Looker offers to calculate the total in addition to the details in an Explore: This has always been a bit tric...
Load filter suggestions for dynamic sql_table_name
Hello All,I have a scenario where I need to pick a database/schema for a table based on a user selectionbelow ...
extract text between asterisk
Hi, I need to extract text between asterisk. I’ve used:REGEXP_EXTRACT(Field , '[^*]+[^*]')And the result is.. ...
Defining different measures on a common Calendar date dimension
Hi, I am a bit stuck in modelling my use case in looker in a good way. So, I have a User explore which is base...
Tracking Pill clicks in Looker dashboards
How do I track pill clicks in my Looker Dashboards. There’s no event that is being registered in System Activi...
Model configuration overrides model data connection
When I configure a model, I can choose which data connections that model will access.Let’s say I have model ab...
malformed SQL for specific filter char
(i use snowflake)sequser sets filter as "contains" and puts 'test$%^23' (without quotes) then sql contains a s...
How can i parametrize SQL table names
Hi all,I have a dataset in big query, inside that i have multiple tables.in looker where i can parameterize Da...
Input so user can save notes in dashboard
So I have a dashboard where it would be helpful that the users can put some notes on it, I’ve tried MARKDOWN u...
render html markup of words inside text
I am trying to apply html markup to individual words in a sentence. The behavior I want works on individual re...
Dynamic table where field names are in name_ column and values are in text_ column how to query for visualization
I have a table data source like shown in the image Where the name_ field will store the field names and the te...
How can I convert Float data type to location in Looker
In view file I am extracting some dimensions from another view file/table which has Float as their data type. ...
undefined method `*' for nil:NilClass
I have the following error when clicking run in explorer:undefined method `*' for nil:NilClassWhat does it mea...
Dynamic Date Filter Comparisons
Use Case: You want to compare two arbitrary time periods, and more specifically want to be able to display thi...
Filter manipulation
Hi, pls Is there a way a particular dimension field used as a filter and not a value in it can be made not to ...
Query API
In Advanced Tier of Looker what does it mean by Looker has 100K query API limit? Can somebody explain this in ...
Using constants for label causes 'X' (errors) or (warning) but works fine
Im using constants in our manifes.lkml for labelsconstant: tie { value: "Tienda" export: override_optional}It ...
How to write a formula that uses Numerical constant linked to filter selection (drop down)?
This would be the logic:e.g.:Casewhen CONTAINS_TEXT(Country drop down,"us") then ((Clicks*0.015*2000)-Cost)whe...
Syntax error when trying to JOIN from 2 tables
Hi, i am trying to run a query to select information from two tables. i am getting syntax error near ‘join’The...
Can i join two explore together?
I wanted to union two explore in one big explore, is it possible to join both explore or what should i do in t...
can we liquid if else with templated filters instead of case when
Hello,I came across one use case where I had to assign multiple filters based on a specific value of a dimensi...
Table calc question
In case of a null value in my look, how can I use a condition that will refer to previous column’s same row va...
Can we use liquid parameters in string filter field to assign dimension values to be used as dynamic filters
Hello,I came across one use case where I had to assign multiple filters based on a specific value of a dimensi...
グラフの並び替え
少し気になることとして、並び替えが２つまでしか設定できない。ソートするフィールドを新たに追加しても、SQLのORDER BYが使えない。何かいい方法はありますか？
how do I fill in nulls in explore?
I’m doing a left outer join and sure some are not going to be 100% match, hints the left outer, but how do you...
