Drilldown on derived dimension
I am using Standard BQ SQL and trying to create a hierarchy on a dimension dimension: category { type: string ...
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
Dimension, return the latest date
Hello Looker community, I am trying to write a dimension (last meeting date) that will return the latest date ...
View fetch data from an external API
Hi all,I have a simple question, is it possible for a view or look to do an external API call and with the res...
how to create global filter that filter on greater then (>) and not on equal to (=) ?
I want to use global filter in my dashboard in a different way I want to show in the filter options the availa...
Creating Another Dimension Value Dependent on Other Values of the Same Dimension
Hey all,I’m trying to create another value of a dimension that would involve a calculation among other values ...
Connecting multiple strings as a new measure
Hello! I am wondering how to combine two strings (two different columns) into one new columnI am trying to com...
Is numeric comparison of parameter value in liquid syntax possible?
I have a parameter where the user would enter a number of days. I would like to be able to set some logic base...
Q1
A LookML developer adds an access_filter parameter to an Explore. When using the Explore, the developer notice...
Looker Maintenance Exam 2021
Let me know if anyone has completed the Looker Maintenance Exam 2021. Please share your views so it will help
Pulling measure values from views inside union block
I have a use case where we have a union view. This view joins 3 views with UNION join and with WHERE condition...
Illegal circular project dependency
Hey, Looking for suggestions on how to best architecture our models, using remote_dependencies. We want to be ...
LookML Parser/Validation Order with Liquid Variables
Hi there,I have base view with a dimension that need different joined fields according to the explore.I want t...
Dynamic Measure with input selected by user
Instead of creating multiple measures for a bunch of variables, I’d like to be able to create one with a dynam...
LookML Validator Misses Case Statement Errors
dimension: example { type: string sql: CASE WHEN ${order_amount} > 100 THEN 'Large' WHEN ${order_amount} > 50 ...
Extract substring based on delimiter
HiI want to create three new columns from an existing dimension(called category) which has upto 3 keywords in ...
“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...
| User | Likes Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
