I have two views:country.view view: country { sql_table_name: my_project.my_dataset.country_table ;; dimension...
I have two dimensions in my looker view file like this: dimension: start_location { type: location sql_latitud...
In view file I am extracting some dimensions from another view file/table which has Float as their data type. ...
Im using constants in our manifes.lkml for labelsconstant: tie { value: "Tienda" export: override_optional}It ...
The problem is that I have a measure that is defined in a refined view that then is joined into an explore. Th...
We have a daily data feed to BigQuery for most of our data tables. In the past we used SQL Runner in Looker to...
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...
The ask is to find out the best way to pre-filter out inactive records in a view file. Right now we are using ...
Hi,Filter a column based on wild card characters. I want to filter values ending with ‘ABC’ from Col A in View...
Previous year, the US based organization I work for launched in the Europe. While this was super exciting for ...
I have a view_A and a view_B which contains a derived table. I am trying to reference a 'timeframe picker' par...
I do not get any error while passing a date range to ‘rev_rec_date’ in SQL runner, but getting an error ‘:inva...
Hello All,I have a view called patient, and a view called risk. Risk has a foreign key patientId to patient, a...
@Jeff_Garcia , We are facing the same issue. We have created multiple views files using derived table from a m...
I have a dimension group like this--dimension_group: timestamp{ type: time description: "day-month-year time o...
Does someone know how I can use this type of sql in Looker?Select , count(case when tickets= 'A' then id end) ...
wanted to add something like this but not able to find a correct syntax--measure: total_revenue { type: sum sq...
can someone help me with how to find the difference between 2 dates? date_diff() or diff_days() is not working...
Pretty much what the title is asking. Could you measure: field_1 { type: count HTML: Inform (default) {{ field...
When trying to create views in Looker from a table (located in BigQuery), i sometimes get this error and the l...
I have got a database with a very strange order architecture in which any order might have a parent. Sometimes...
I've created views from underlying GBQ tables. I'd like to dynamically update the views every time a new colum...
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...
In a new project my Model wont recongize view name?? For this test case I am using the Looker Hub and not GitH...