Error: Creating an NDT with bind_all_filters on an explore which is extended

Looker Q&A Looker
1

Hi all,

We need to create a dynamic top N ranking on a dimension and we feel like creating an NDT with bind_all_filters parameter is the most elegant solution. However, the base explore we’d be using to create the NDT is extended by multiple new explores, thus, we’re getting an error:

Cannot use native derived table "My NDT" with "bind_all_filters" outside of its source explore "My Source Explore"

The NDT view is not available in these new explores through the explores fields parameter.

Using only bind_filters parameter with hard coded fields work, but our end users need to filter to low granularities, so using only one filter field doesn’t yield the desired outcome. Are there any workarounds to this error?

1 Like
2

@TeemuMetacore - Could you provide a little bit more context about how you’re trying to extend your explore? If you could share some more of the code for the NDT and the explore that it’s based off of - that would be helpful to understand if there is a workaround.