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...
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
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...
Add more preset values for Looker Timeframe Filter
Can we modify this preset options in Timeframe Filter. I want to add Last 120 Days Preset option to this. Is t...
EXPLAIN is not working in Looker Sql runner
Hi Team ,We are using Big Query as data warehouse and I am trying to analyze the sql query performance using S...
Firebase Block - Derived Tables Issue
I am currently using the Firebase block available on Github. When generating one of the predefined derived tab...
Validation doesn't capture incorrect sql_on
quick validation rule to highlight error like sql on ending with “=” should be done
Extend an unnested field
Hello!I have a nested field in Big query table that I want to unnest and use it in an extended views with “ext...
Looker LOOKML will not accept double quotes for passed condition
When passing a filter from an Explore like in the below example for whatever reason we cannot get it to provid...
set format for a looker dimension name
Hello, Can I set how a dimension is shown in explore? For example for a dimension "Product_name_n”, can I make...
Co2 Emissions Target and Possible paths calculation
Hello Good Lookers,We have a requirement at my work and could not think of a solution.We are analyzing data on...
How to create flexible GROUP BY on LookML
This is the function generated in SQL, I want to include c.bkg_no, c.cntr_no, c.cntr_tpsz_cdm on GROUP BY belo...
Include all fields in Liquid variable
Do Looker support a variable name that include all the fields in the query?For example, I have this Liquid: {%...
