Rank Calculation Issue

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.

0 1 199
1 REPLY 1
Top Labels in this Space
Top Solution Authors