Filtering a variable based on a custom filter
Hello, everyone,I want to create a user-input filter (with some predefined values) and then use that input to ...
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
Use remote depencency(import) for release instance?
Hello, i am creating a new instance for testing. In normal workflow, we would develop in a develop branch, pus...
bigquery.jobs.create
getting below error can any one suggestbigquery.jobs.create
How to load budget details from GCP to Looker?
I need to create Budget vs Actual dashboard. Is there any possible way to integrate budget details from GCP co...
change table names according to envirnoment
hello , i currently have a production environment and want to create a release one. The sql_table_name is goin...
Create HAVING clause and GROUP BY without it in SELECT clause
Hi, Is there a way in LookML or within the Explore itself to replicate the following SQL query - where `order_...
How to merge colum on looker langage (RMS tools)
Good evening everybody,I am working with hospitality industry using a RMS (Revenue Management System) tools ca...
Designing the perfect model
What is the best approach when you have billions of rows in one table, should I make a star schema and make ag...
Can I use local_project_import to refine system activity?
Hi!I would love to refine the system__activity model (better drills, different measures), is there a project n...
subtotal error impedes schedule
query failed: Requested subtotal on field [explore.field] but it was not in the grouping fields. Subtotal igno...
Looker PDF document generation fails and scheduled reports fail to go out!
Recently our scheduled reports stopped and the PDF generation feature fails to work. The Looker support team r...
Hierarchy of User Attributes and Access Filters to access more or less in dashboards off 1 Explore
Hello,I need help trying to approach accessing different user attribute data across dashboards for a single ex...
How to calculate quarter to quarter increase in LookML?
I filter my data using a date filter shown below.Then I create a Single Value Chart for my sales index using f...
like operator
Hi guys does anyone knows how i can create a condition on my model to restrict a specific texti will like to h...
Retrieving values from the last row
Just found this and thought I would put it up here as a brilliant solution that I’d never considered. I have b...
I am new to the Looker, Please help me to filter timeframe measures with wtd , ptd, std and ytd.
In addition to the topic I am looking like I run a LookML for any given date the measures wtd, ptd, std and yt...
How does Looker order expressions within a with clause?
I have a cascaded derived table with unions in it, something like:derived_table: { sql: select * from ${view_1...
Dinamic URL - fitler name switches to special character
Hi!Scenario:have a dashboard that have links to another dashboards and I want to persist filtering between the...
Conditions in Join Clauses (3.20+)
Release 3.20 (still weeks away when writing this) will come with the ability to add conditions in Join clauses...
join based on multiple conditions
I am trying to join 2 tables in the explore using sql_on.The first condition is ON and the second condition, I...
Can't find the dashboard link source
I have a really weird issue. Some dimensions in my explore have a link to a dashboard (Consultation Vehicule, ...
Help using Case/when/then in custom field (dimension) with conditions relating to null values
We are using looker through Chrome River (Emburse Analytics) and trying to combine 3 fields into one. We have ...
How can I modify week_start_day with refinements?
I'm investigating moving to a structure where we have a base project that gets imported into multiple client p...
Clickhouse stable view same as normal view?
When testing in SQL runner, I found that I cannot query data from normal views in Clickhouse.I found the doc s...
Move HTML element without using position (inside a measure)
I'm trying to change the position of a link I add in Looker measure, inside the HTML section.It's a kind of CS...
Localization for type: button, type: text, and type: single_value in LookML dashboard
Is there a way to localize the buttons/text/single value in a dashboard?It seems that localization works only ...
End date rows are not merged after download
Hi,I have on Visualization table legacy some data which are grouped by “End date”, but once I download the fil...
Dim Date table to another table How to create relationship? b/w two tables?
Hi Team,i have a 2 tables called product and dim_date.now i have to create relationship b/w the two tables usi...
Contains with list of strings
Hello, i want to create a custom fitler on a look, and exclude rows that contain a list of strings in their na...
Weighted Average in LookML using measures
I have gone through https://community.looker.com/technical-tips-tricks-1021/how-to-make-a-weighted-average-302...
