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 ...
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
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...
Parametrised values not working as expected
Hi,I’m trying to use parameters to switch between different columns in a visualisation. So the user can select...
Inherit labels from BigQuery
Hello community!We use labels in bigquery to define ownership of datasets and tables, e.g. fact_attributions i...
Apply different If arguments to totals
Hello smarter people than I,I hope that you are well today!Does anyone know if there is a way that I could cre...
Moving calculation column within Merge Queries
On my merge quiries, I created calculation between two queries. As default all calculation are placed at the v...
Unknown or inaccessible field when following PoP tutorial (again!)
I’m following up on my previous question as I have two other Unknown or inaccessible field error that seems to...
Unknown or inaccessible field when following PoP tutorial
Hello. I’m following this tutorial https://blog.montrealanalytics.com/the-ultimate-guide-to-period-over-period...
Explore not available in development mode
Hello. I’m new to Looker. I’m trying to create my first model. I’ve switched to Development Mode and I’ve crea...
Dynamic Parameter Values
Hello all,I was just wondering if the future versions of looker are going to support dynamic parameter values....
Dashboard performance when drilling in the view vs in the measure
Hi All,I’m experimenting with adding drill_fields, either to the measure itself or to the view in general. I’m...
Tabbed Dashboard in looker
Hi I would like to create a tabbed version of looker dashboards. I have two existing dashboards but i want to ...
How to connect tables in datasets belonging to different projects
i have a requirement, where i need to join tables in different datasets belonging to different projects
[Analytic Block] Measuring Activity and Engagement
About This Block Tracking users’ activity and engagement allows you to dig beyond a simple user count like Dai...
Grouping Fields Within Views (3.44+)
Some users have wanted greater control over how fields are grouped in Looker’s field picker. Looker 3.44 adds ...
LookML error happens when switch to new LookML runtime
When I apply new_lookml_runtime: yes in the manifest.lkml, a LookML Error appears. The error message is someth...
Is it possible for an Explore to join a view which includes a liquid variable to itself?
I have a user_history table with roughly 100 fields, in which each record has a start_date and end_date. I’d l...
Configure the "Run Test" button to do the equivalent of "Run LookML Test"
Hi there,We have Require data tests to pass before deploying this project to production set as true because we...
I want to calculate last n days/month sales based on selected date
from the screenshot for amount streamed 2 i want to see last 3 days on row 1 as (126+587+200)any help with a m...
Blending Data - Day and time Chart
G’day,I’m trying to return the “Day of the Week” and “Time of Day” from a 2 source data blend but have been un...
Adding a custom dynamic filter to LookML dervied table
I need to add a dynamic filter to a view so I would only have to change the filter when changing the parameter...
change contant according to looker instance i am in
i have 2 different instances of looker (test / prod) and i am trying to create a constant according to the ins...
sql generated in explorer is weird
Hello, In lookml i have one explorer :Example : explore: toto{ join: tata{ type: left_outer relationship: one_...
organize views inside a folder
Hello, Is it possible to have in one explorer that hierarchy : Folder 1 view1 view2Folder 2 View3 View4…thank ...
Do PDTs behave different in Dev Mode?
I was testing a PDT in dev mode that took about an hour to complete, but it seemed to keep getting cancelled b...
Defining JSON Objects as LookML Dimensions
When you come across JSON objects in Postgres and Snowflake, the obvious thing to do is to use a JSON parsing ...
