Is it possible to extend two views and use a LookML parameter in the extended view?
I have two views:country.view view: country { sql_table_name: my_project.my_dataset.country_table ;; dimension...
Forum Posts
Change the color of dimensions in Map
I have two dimensions in my looker view file like this: dimension: start_location { type: location sql_latitud...
How can I convert Float data type to location in Looker
In view file I am extracting some dimensions from another view file/table which has Float as their data type. ...
Using constants for label causes 'X' (errors) or (warning) but works fine
Im using constants in our manifes.lkml for labelsconstant: tie { value: "Tienda" export: override_optional}It ...
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...
Best practice: writing views in BigQuery vs Looker
We have a daily data feed to BigQuery for most of our data tables. In the past we used SQL Runner in Looker to...
Accessing View date_time parameter from Explore
Hi there,If I'm looking to add in a date criteria to the sql_on parameter in an Explore join, am I able to lev...
Filtering out inactive records at the View level
The ask is to find out the best way to pre-filter out inactive records in a view file. Right now we are using ...
Filter a Column using wildcards and LIKE
Hi,Filter a column based on wild card characters. I want to filter values ending with ‘ABC’ from Col A in View...
convert utc_departure_date field in airport local timezone in Looker view
Previous year, the US based organization I work for launched in the Europe. While this was super exciting for ...
Error referencing parameter of a different view
I have a view_A and a view_B which contains a derived table. I am trying to reference a 'timeframe picker' par...
Look ML
I do not get any error while passing a date range to ‘rev_rec_date’ in SQL runner, but getting an error ‘:inva...
Using a field from a different view
Hello All,I have a view called patient, and a view called risk. Risk has a foreign key patientId to patient, a...
How to use views with multiple database tables in same model
@Jeff_Garcia , We are facing the same issue. We have created multiple views files using derived table from a m...
How to add hours to my timeframe field?
I have a dimension group like this--dimension_group: timestamp{ type: time description: "day-month-year time o...
how to make case dimensions out of a column?
Does someone know how I can use this type of sql in Looker?Select , count(case when tickets= 'A' then id end) ...
How to add multiple values in multiple filters within the same field inside a view?
wanted to add something like this but not able to find a correct syntax--measure: total_revenue { type: sum sq...
difference between dates and grouping the results by another dimension
can someone help me with how to find the difference between 2 dates? date_diff() or diff_days() is not working...
Is it possible to use the new Looker Components in a views HTML parameter?
Pretty much what the title is asking. Could you measure: field_1 { type: count HTML: Inform (default) {{ field...
Conversion fail when generating LookML view from table
When trying to create views in Looker from a table (located in BigQuery), i sometimes get this error and the l...
Dimension using other view that is joined many times
I have got a database with a very strange order architecture in which any order might have a parent. Sometimes...
Automatically Refresh View when a Column is Added in GBQ Data Source Table
I've created views from underlying GBQ tables. I'd like to dynamically update the views every time a new colum...
View fetch data from an external API
Hi all,I have a simple question, is it possible for a view or look to do an external API call and with the res...
New Project - Model wont recognize views
In a new project my Model wont recongize view name?? For this test case I am using the Looker Hub and not GitH...