Question

Rank Calculation Issue

  • 7 August 2021
  • 1 reply
  • 27 views

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.


1 reply

Userlevel 6
Badge

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.

Reply