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...