How to add a button to lookerml dashboard with filters in query parameters?
- dashboard: test_dashboard title: Test Dashboard layout: newspaper preferred_viewer: dashboards-next elements...
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
Counting unique id's in one column
Hi,I am new to Looker and am having various success and can see its a very powerful tool but i have hit a poin...
Code not saving CSV
I have the following code, what it does is it uses the client id and client secret to get an access token, the...
Multiple hyperlinks in one cell
Is it possible to show two or more hyperlinks in one cell in Looker?
Color coding on one dimension based on the values of another dimension
Is it possible to have conditional formatting on one dimension based on the value of another dimension in Look...
Change the color of dimensions in Map
I have two dimensions in my looker view file like this: dimension: start_location { type: location sql_latitud...
Aggregate Awareness with filter only fields?
I have a big partitioned table which I want to add aggregate awareness to. However, it uses a filter only fiel...
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...
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...
