Customer Rank globally & regional in one Board Widget?

Hi Daniel,

One method that I believe you could use to achieve your desired functionality would be to use an input metric to manually filter the ARR before applying the RANK.

Let me take you through a small example to demonstrate how to do this.

Firstly, lets take the below ARR metric. This is dimensioned by the Market dimension list. Each Market is mapped to a Region, and this relationship is displayed in the rows. (I do not have Month as a dimension here, as you mentioned in your question, but I believe the logic could still be applied).

I then create a ‘Rank Grouping Input’ metric. This is a metric of data type Region that has no dimensions.
 

With these first two metrics, I can now create a metric that gives me the ARR of the Markets that are mapped to the Region I have selected in the second metric. Note that the formula ensures that if no Region is selected, then all Markets are shown.

And then the final metric, which applies the RANK function to the output of the previously mentioned metric. If I select the Region of EMEA in the ‘Rank Grouping Input’ metric, then I end up with the output below.

If I put some of these metrics together on a board, I could end up with a view like in the screenshot below.

Hopefully this solution makes sense and you can leverage it to resolve your query.

Cheers