Configuring a dynamic explore_source in Native Derived Table?
I’m trying to make a generic view to allow “Top N” rankings on pivotted Looks (eg. line-chart timeseries). I’v...
Forum Posts
stddev_pop producing incorrect results?
Hi,I’m trying to return the standard deviation of a dimensionalized measure in an NDT but am getting incorrect...
[Analytic Block] - Pivot by Top X - Introducing bind_all_filters: yes
Pivot by Top 10 You’ve got a high cardinality dimension and you’d love to just see the Top 10 based on some me...
Templated Filters for Dates in Native Derived Tables
I’m trying to implement a templated filter to filter a derived table using a dynamic date parameter, much like...
How to create Native Derived Table with brand wise Rank() over order by Sum of Sale price.
Here I want to create rank column with help of Sum(sales) aggregation value in the same query. select brand, S...
access_filter and native derived table
Hello Looker Experts, After adding an access_filter to an explore I get the following warning:Persistent Nativ...
Native Derived Table Filter
Hello all,How would I apply a NULL filter on a Native Derived Table using an explore source? I understand how ...
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...
Subtotals using Native Derived Tables and Templated Filters
We often hear requests to produce subtotals in Looker explores. Here’s a pattern to do that using Native Deriv...