Derived table SQL: Standardising test to control in Looker dashboard
Hi,I’m building a Looker dashboard and in it I’d like to standardise my test values to control spend (at the m...
Forum Posts
How to select a particular columns based on a filter in Derived table
How to select a particular columns based on a filter in Derived tableeg. select a,b from tablefilter values (b...
Can I use original database table/view in a derived table without importing it as a view or explore in Looker?
I have 4 (A,B,C,D) tables in DB. I have imported A & B as Views (View_A and View_B) and used them in a model e...
Temp derived_table creation failed: Unknown database 'looker_tmp'
Hello,I’m trying to create a temporary derived table and get the following error: “temp derived_table XX creat...
Cannot specify both sql_table_name and derived_table for view
Hi i want to create a derived table using sql in my view only that sql query is a composition of two unions of...
Dynamic Cohorts
Hello,Our team is currently working on several requests that involve the ability to create custom cohorts. Her...
How to Query from one Project and Write PDTs to Another with BQ
Hi all,I have gotten question about writing PDTs to a separate BQ project, but we want to able to query tables...
DB Connection types in looker
Hi Team,I am I am very much new to looker and we are in process of migrating from Tableau to Looker. I would l...
Native Derived Table > Auto-gen LookML for existing Explore table calcs
Hi Folks,Looker newbie, apologies in advance.I’m hoping to build a native derived table, to aggregate the resu...
Dimensions from DT empty
Hi all,I think it’s a simple question but I do not understand the logic. Please find below the example.Main vi...
error derived table
Please, I want to create a derived table and bigquery as the database and i have this error :Query execution f...
Conditional liquid filter - string matching not exact
Hi - I want the user to be able to input a value in a filter in a dashboard and then apply that value within t...
Derived table - To use filters created in the Case When Clause of the Derived table create Syntax
Hi,I have created a derived sql view with some filters in it say:“filter: abdc { type: date)”Now I want to use...
PDT .publish_as_db_view: yes
Hi All,I want to be able to query my pdt through a view since the PDT name changes every time with a new rebui...
Aggregate awareness - filter values
Do you know of a way to include multiple values in the filter of an aggregate awareness table, and get looker ...
Calculating User Repurchase Rate
Definition: How frequently do your users, who have already purchased an item, purchase again? Example Mary buy...
Use User Attributes to set derived table name dynamically in sql_table_name
Hi,I try to set the derived table name like ${derived_table.SQL_TABLE_NAME}, in user attributes and use it in ...
Drilling into a Measure after it has been "Dimensionalized"?
Hi all! I am wondering if there is a way to preserve a Measure’s drilldown after it has been “dimensionalized”...
When does old PDT get deleted?
I am seeing the error “relation ‘looker_scratch_XXXXX’ does not exist” quite often. This usually resolves itse...
BigQuery UDFs in Derived Tables (or sql_preamble in Native Derived Tables)
I’ve developed some BigQuery UDFs (to remove non-business time between two timestamps) that we’re currently le...
Inaccessible view error on derived table
I’ve got a couple of tables in my data that require being joined to other tables in order to calculate certain...