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...
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
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...
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...
