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 ...
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
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...
Can we restrict filter condition options for strings?
Hi,I have a filter for string type and in the dropdown it shows the options based on which we can filter, Can ...
Calculating totals when using GREATEST - interesting case
An interesting case I discovered today, which may be useful to make a note of. Let’s say I have three measures...
Filter based on list of entries of another table
Hi all,I am trying to how i can achieve the following in lookerI have 2 tables, Table_A and Table_B I would li...
Looker explore question
Hi, I’m building a dashboard on looker which calculates previous period which is displayed on a tile just belo...
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 ...
can we reference count measures from other views?
I have 2 measures in view 1 - one is a ‘number’ with sql just defined as ‘1’, the other is a ‘count’.I have an...
