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.