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 ...
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
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 ...
Multiple selection dropdown menu with a SQL DISTINCT UNION of values
Hello,I’d like to create a dropdown filter of approximately 70 values, the values are from an SQL query of the...
Red dots in front of my LookML
I tried to find what these dots mean but couldn’t find it. The code seem to work, but maybe is there some prob...
Why does HTML link not work in dashboard but works in explore/look?
Hi, I’m trying to create drill down analysis using HTML link and parameters. If I click on country and pass th...
Compare Current Day with the last 7 days average
HiI’m trying to build a look/table which shows a measure for current day value, as well as an average of the l...
LookML cannot parse Liquid
Hi Looker team,Database Dialect: BigQueryContext:We build the SQL-based derived tables.In the SQL, there are s...
LookML Dashboard: Restricting values in dropdown filter
Hello I am creating a LookML dashboard and currently I have a field_filter which allows the user to choose fro...
Updates to Looker Blocks
Hello,My question is a basic one but I can’t seem to find any good information on it.If a Block is updated to ...
Count non-distinct values in a dimension
Hi,How do I go about count non-distinct values in looker explore for one dimension.I can write this in SQL but...
Hiding some but not all fields in a dimension group
Hi I have a date dimension group that has the following structure: dimension_group: date_created { type: time ...
Error: Dimension containing a link joined into a explore causing blank screen when used
When I try to bring a dimension into a Look my page just goes blank. I have isolated the cause but am unsure o...
WEEKDAY function not found
Hello Folks,I want to return the current date as an index. So, I was using the weekday function WEEKDAY(NOW( )...
Connecting looker to views SQL server
Can we not connect to views created in SQL server?
Identifying Looker content impacted by LookML changes
Is it possible to find the impact of our lookml changes on other dashboards or which will get affected because...
How to implement private embedding in looker ? also not sure where we can add iframe
How to implement private embedding in looker ? also not sure where we can add iframe
Word Frequency Analysis / Word Clouds: Analytical Pattern
The Objective: Looking to analyze text fields? Want to understand top or trending keywords? Some common use ca...
Localization for title_text in Dashboard
We are localizing our lookml dashboardsWe have title_text in dashboard configuration as follows- name: 'Quarte...
FIiter an explore before join
Hello, so I have two problems.PROBLEM1So, I have this explore and join in a model. I want to join some values ...
