LookML   SQL & Derived Tables


Join happening when it's not needed (3)
Calculating KPIs with non-existent data for some employees (5)
Repeat buy analysis problem (3)
Percentile as Dynamic User input (5)
Indexes on multiple columns in derived table (11)
Summarizing over Start and End Dates (3)
SQL Pattern: Summarizing entities with a start/end date over time (1)
Changing PDT with templated filter. PDT does not rebuilt? (2)
How to count only weekdays between two dates (5)
Horizontal -> Vertical, multiple values? (2)
Fill forward: Possible? (4)
BigQuery UDFs in Derived Tables (or sql_preamble in Native Derived Tables) (7)
User attributes and derived tables causes regenerator errors (2)
Update PDT when both tables are updated (3)
How to avoid order by in Look SQL? (2)
Update and insert PDT instead of reload (6)
Dropdown in explore to change column in a derived table (2)
View PDT (Persistent Derived Tables) details (2)
Looker user attributes and `if dev` to auto-switch between dev & prod schemas (4)
Scheduling PDT on day of week at a specific time (3)
Unknown parameter "indexes" in derived table definition (4)
Datagroup on max id from the table and date of the view? (4)
Flag Insert Update and delete source record in target using informatica (1)
PDT Naming: Development vs Production (3)
Uses of if dev (3)
Error: Illegal mix of collations (7)
Join derived table to itself (2)
[Retired] Using Native Derived Tables ( 2 3 ) (44)
Grouping dimension with contains of another dimension (3)
Cumulative Sum in MySQL (6)