LookML model join is using fields as numeric when they are both defiled as string
Hi All I am getting the following error in a LookML model on a join - it seems to be trying to join post codes...
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 do I set a liquid parameter based on a dashboard filter?
Hi all,I have a LookML dashboard with a filter for two looks- dashboard: overview filters: - name: time_spec t...
Color coded bubble chart on maps
I am looking create a bubble chart / scatter plot on the map. something like below. I want the size of the bub...
Drill Down not working
Hi team,I have created a drill dimension as: dimension: Drill_Dimensions { sql: ${TABLE}.id ;; drill_fields: [...
[Bug] Custom grouping errors are not picked up by Content Validator
We changed a view name recently and the tiles containing custom groupings based on that view got broken. Howev...
Create a read only branch
Hi I can create a new branch in looker but it ends up becoming a shared branch.I would like to create a read-o...
How to create dimension that can filter date to show just the most recently uploaded data?
I am working with an underlying database where there is 1, 2 or 3 day lag with importing dataI want to build a...
"Operational" Reports vs "BI" Reports
Hi,Does anyone have any experience using Looker to build traditional listing reports with multiple sub reports...
Can I use 3rd-side API as a datasource?
Hi, how can bring my own data to Looker with RESTful API I already have? Or should the datasource always be a ...
Count of greater than and less than values
Hi Everyone,I have a dimension that calculates user engagement score and based on that I want to calculate the...
Timeframes and Dimension Groups in Looker
Read about dimension groups in our docs here as well as available timeframes here. When analyzing time-based d...
grouping number and string data types into one dimension
I have two different data types in a dimension , number and range under the dimension for employee size:e.g. 1...
Having issues to pass filter on partition filter as argument to derived sql in LookML
Hi,I have a hive table with datestamp as partition in 'YYYYMMDD' format. I am trying to design a view with a d...
The updated Period-over-Period Guide by Montreal Analytics
Hello Looker folks!The team @ Montreal Analytics has updated our popular Period-over-Period block!You can find...
Import Predefined CASE WHEN statements into views
Hello, We have, in several lookerviews, CASE WHEN functions that translates a fixed inputvalue to a specific o...
Access to date dimensions from SQL:
Why I can access to number or string fields, but not to Date fields?view: test2 { derived_table: { sql: WITH E...
Sub Query Error (
Hi Team,I am trying to develop a query in SQL Runner as below and it gives me error. I want to compare two dat...
How to refer to user created filter value?
If the user creates filter for a columnI can check it with `_is_filtered` but how I can insert value from this...
Creating a 'set' of pivots
Hi there, I have a dimension with values ( let’s say a,b,c,d,e). I have an ask from specific users to present ...
How to identify Looks/Dashboards that use a Specific Table
Hi all!We have a table in Looker that we want to delete. But we want to identify any Looks or Dashboards that ...
Parameters - Unexpected behaviour
Hi all,I’m using a Parameter that I pass into a Dynamic Measure and into an HTML field that I use as a separat...
Ability to set different group labels for fields for different explores
We have group labels set for views/explores that are joined into other explores. Often, we’ll only join a few ...
Using a BigQuery Array in drill down Look ML
Hello,I have a bigquery field with the following schema:Where as endpoint is a key and it has a array with uni...
How to pass liquid parameters to `date` fields filters?
How to pass liquid parameters to `date` fields filters?I can pass parameter to string filters like this filter...
How to configure first appearance of date filter in `in range` state?
How to configure first appearance of date filter in `in range` state?If I declare filter `type:date` like this...
Extract month from iso timestamp
I have table column which consist of timestamp like "2021-06-11T13:16:52.083Z" . I want to extract month, year...
Hew insert value from filter into aggregated measure filters
How correctly refer to filter or parameter in measure filters section?I do not want to use SQL
Declaring views and explores in the Manifest file.
I sit possible to declare the views and explores in Manifest file?So, if someone else want to use my looker mo...
Why aggregation functions does not work?
My aggregation functions are not working!I am expecting calculation results AVG, SUM, MAX in measures, but get...
dynamic filter Axis change
I have a dynamic filter (in filter Revenue and Transaction Quantity). When I choose revenue it should change Y...
