Rank Calculation Issue

[BIDevSonu]

I have created Rank using SQL derived table, would like to know how can i make it dynamic.

Issue I am facing is Rank is not getting calculated properly while applying filters at explore/dashboard level, looks like those filters are not getting applied on derived table and rank is getting calculated before the filters are applied.

I am little new to looker, pls advise.

[IanT]

Take a look at native derived tables (ndts) and something called bind_all_filters.
This will build the derived table dynamically from your explore (rather than writing out sql) and will apply all filters or a specific filters if listed to the subquery before joining it into the main analysis.