Extract substring based on delimiter
HiI want to create three new columns from an existing dimension(called category) which has upto 3 keywords in ...
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
Conditional formatting of color or images within table cells using html
Imagine you have a field in your data called status, which gives the status of each order. The possible values...
“Resources exceeded during query execution” in BigQuery because of cartesian product
BigQuery charges per query based on how much data it has to scan. It then allocates server capacity to your qu...
Export custom fields
Hey allI have approx 12 custom fields where i need to export values from that have fixed dates.I would like to...
Dimension parameter to take labels from different field
This has been on my mind for a while but it gets to me every time I have to deal with maps, which is the best ...
How do you draw your Looker architecture?
Hello all,I’m currently working on a project with connection on bigquery with (a lot) of tables.When you’re co...
union of 2 views with different data set loations in bigquery database
i am trying to create a union with 3 database views under derived table with 2 of them with dataset location “...
Aggregate tables and symmetric aggregation
https://docs.looker.com/data-modeling/learning-lookml/aggregate_awarenessI have an aggregate table that is bui...
How to avoid/limit usage of dims and measures from two different views (unrelated structs) tied to common key in an explore?
I have a table with two unrelated repeated structures tied to common key and using this table to create an exp...
Update git production branch to be "main" not "master"
Hi,I’m currently running 7.20.48 self hosted.I can’t figure out for the life of me how to change the “Producti...
language User Interface
Hello, how to change the language of the user interface.I went to localization but the language was not change...
Looker date filter for last year
Hello everyone,I’m new at looker and while doing some operations i found myself in a positiion where I need to...
Calculating a monthly total between two days
How can I calculate a monthly total given a total amount, a start date and an end date.For example: I have a t...
PDT
Hello, please how to create the derived tables in our database to see the data they outside of our dashboards ...
Proper case for BigQuery
I was struggling trying to find a way to capitalize names in Looker with data coming from BigQuery, since BigQ...
Applying dynamic filters on Links as Drilldowns
Using the [drill_fields] feature to apply a Drill Down into the data is great but it’s missing some key featur...
Parameters Values
Hello all,i have a few parameters added to my view file which are used to query an ML model in BQ. Problem is ...
Dynamic yesno using filter
Hey,My goal is to create a yesno dimension based on whether or not a row’s value is ≤115% and ≥85% a filter’s ...
Pass parameter to 'map_layer_name: '
I want to allow for a map to be built either for world countries or US States. I have created a parameter pick...
SQL UNION
Is there likely to be some way in the future to do this in Looker without writing a derived table?
Shouldn't the symmetric_aggregates parameter apply to joins rather than explores?
I’d like the ability to turn off symmetric_aggregates for particular joins where fan out is expected and OK. W...
Date differcence
Hi everyone, I have a payments database which contains a binary varialbe (true / false) called First purchase ...
IF with an unquotted parameter
Hi! I am trying to use a IF with an unquotted parameter but it does not match. dimension: period_2_start { hid...
LookML Developer exam
Hi All, I am planning to do a LookMl developer exam. Please, can anyone recommend good resources for this and ...
error date filter
Hello, if I put a filter on the date field I have this errorinvalidQuery: No matching signature for operator >...
filter
Hello i have 2 views and each view has a date field but i want to use a single date field to filter the measur...
BigQuery + Looker: Timestamp vs Datetime
Hello, we have Looker on top of BigQuery. Currently there is a lot of mixed usage when it comes to dates and t...
Best format to ingest forecast data into Looker ?
Hey everyone !So I am wondering what’s the best way to ingest forecast data into Looker which is csv/xls forma...
embed looker dashboard from user branch and not from master
Can we embed our dashboards from the personal (user) branch and not from master ? we embed looker dashboards i...
