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...
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
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: {%...
How to use like with a templated filter
I’d like to do something like this: select * FROM table where {% condition topic %} ILIKE title {% endconditio...
Looker liquid syntax error after upgrading to 22.18
Hi Team , I am using two measures like below in my code but after upgrading looker to 22.18 version I am getti...
Change dimension label depending on join
In explore this_viewjoin: created_by_user {from :userssql_on: ${this_view.created_by_id} = ${created_by_user.u...
Custom field formats with and without commas
I accidentally added two “identical” custom fields using the three dots to the right of an String field → Aggr...
Create a dimension to concat the values of another dimension
Hello,Is there a way I can create a custom dimension to concat the values of another dimension?For exampleUser...
How to add a YTD running total measure on a month report ?
I am trying to include in a report that contains data from previous month, a running total for the year. For e...
Joining three views to a single explorer from two different folders in looker
Hi team, I need to create a single explorer where I should join 3 views but the problem here is 2 views are fr...
Convert multiple columns into single column
I have been facing an issue in presenting the multiple select answers (having multiple columns in the excel) s...
In Incremental PDT rebuild derived table feature not working
Whenever there is new data coming in. I use the rebuild derived table feature to pull the latest data.But when...
Why is my Explore insisting on a datetime for the filter?
Hi,I have an underlying database table where the field type is date, and then in the view I had it set as date...
How to get total as a column
Hi all. Could you help me please to understand if it is possible to get totals as column using lookml?I may cr...
Dynamic Period-over-Period Filter Comparison
Hi,Sorry if my English is not the best.I’m working with a client who needs to realize a dynamic comparissons o...
Can we apply pivot over dimension?
Yes, we can by using type: list in Measure field.measure: list { type: list list_field: first_name }dimension:...
Validation - errors out of date not resolving
HI, Working on a Model, and we can’t remove the “errors out off date” no matter how manner times we vaildate. ...
Connection between LoomML model and other BI tools
Hi Looker Community.Could you help clarify if they is an option to connect BI tool with LookML Model directly ...
Help Needed( new to Looker): Fiscal YTD calculation
I am trying to build a look which is essentially this:NetworkId | CountOrder Last month | COuntOrders_Fiscal_Y...
method 3: period on period comparisons using postgres SQL
Hi, I have found this article which helps with period on period comparisons however it is in big query and I w...
How to draw polygon data in looker from json column
I have a BigQuery table with polygons data:| id (int) | polygon_shape (string) |+-----------+-----------------...
Dynamic dates based on Completed period and period to date
Hi all, I was wondering if anyone has set up / knows how to do dynamic dates that are able to filter for day l...
Looker Bigquery External Table Partition Pruning using PDT and Dynamic SQL
https://medium.com/@raigonjolly/looker-bigquery-external-table-partition-pruning-using-pdt-and-dynamic-sql-1b7...
