Dynamic Rank Functionality

Asslam

In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds:

Currently, we have the RANK function work on one dimension or one attribute. Moreover, it does not relate to the event-driven by the context selector. Which creates some fundamental challenges to addressing user requirements to dashboard Top 5 performing Products at different hierarchy levels. (i.e. At state, country, and region levels).

How often is this impacting your users?

This has come about few times in the last quarter

Who is this impacting? (ex. model builders, solution architects, partners, admins, integration experts, business/end users, executive-level business users)

This impact directly the business users to visualize and filter data based on the context filters.

What would your ideal solution be? How would it add value to your current experience?

An ideal solution would be the RANK function to work with dynamic group-by-items

Please include any images to help illustrate your experience.