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...
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
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...
templated filters and derived tables
view: closed_loans { derived_table: { sql: with closed_loan_data as ( select row_number() over (order by coale...
Displaying Latitude and Longitude values in Looker studio
What is the best way to represent Geo data in visualization. I have around 1 million rows Latitude and Longitu...
Inaccessible view error when joining a view with a "from" parameter
The problem is that I have a measure that is defined in a refined view that then is joined into an explore. Th...
I want to calculate top reduced business compared with week/month
Hi team,I want to calculate the change revenue week/month and list all businesses with big change about sales
Test
Test- please ignore
How to ret percentage per value
Hi everyone. Could you please help me with percentage calculation in LookML? I need to count percentage of yes...
Is this a bug on Visualization ?
In Looker while i created a report adding Dim & Measures , the graph stack size are wrong , if you see y axis ...
