Templated Filters for Dates in Native Derived Tables

Looker Q&A Looker
,
1

I’m trying to implement a templated filter to filter a derived table using a dynamic date parameter, much like described here

https://help.looker.com/hc/en-us/articles/360023861633-Templated-Filters-and-Derived-Tables

But I am using a native derived table rather than a sql derived table. Is it possible to use date field parameters in a native derived table?

2

You can use the “bind filters” parameter to link the templated filter on an NDT:

bind_filters: {
  to_field: users.created_date
  from_field: filtered_lookml_dt.filter_date
}

See Here for Details