Function measureBottomRanking

measureBottomRanking( measure, count, config?): Filter

Creates a filter that returns the bottom N values of the last dimension, independently for each unique combination of all preceding dimensions.

This filter applies ranking within groups rather than globally. It shows the bottom N values of the rightmost dimension for every unique combination of the other dimensions to its left. The order of dimensions in your query determines the grouping behavior.

Key Differences from bottomRanking:

• bottomRanking: Filters a specific dimension globally (you specify which dimension)
• measureBottomRanking: Always filters the last/rightmost dimension, grouped by all others

How it works:

• With 1 dimension: Returns the bottom N values of that dimension
• With 2+ dimensions: Returns the bottom N values of the LAST dimension for each combination of the others

Parameters

Returns

Filter

A filter instance

Example

Example 1: Single dimension (equivalent to bottomRanking) - Query with one dimension [Category]

// Returns bottom 5 Categories by revenue
filterFactory.measureBottomRanking(
  measureFactory.sum(DM.Commerce.Revenue),
  5
)

Result: 5 categories with lowest revenue (e.g., Accessories, Cables, etc.)

This produces the same result as:

filterFactory.bottomRanking(
  DM.Commerce.Category,
  measureFactory.sum(DM.Commerce.Revenue),
  5
)

Note: With only one dimension, there are no groups to rank within, so the behavior is identical to bottomRanking.

Example

Example 2: Two dimensions - Query with dimensions [Gender, Category]

// Returns bottom 2 Categories for each Gender
filterFactory.measureBottomRanking(
  measureFactory.sum(DM.Commerce.Revenue),
  2
)

Result: 3 genders × 2 categories each = 6 rows

• Male: Bottom 2 categories by revenue
• Female: Bottom 2 categories by revenue
• Unspecified: Bottom 2 categories by revenue

Example

Example 3: Three dimensions - Query with dimensions [Gender, Age Range, Category]

// Returns bottom 2 Categories for each (Gender, Age Range) combination
filterFactory.measureBottomRanking(
  measureFactory.sum(DM.Commerce.Revenue),
  2
)

Result: 3 genders × 7 age ranges × 2 categories per combination = ~42 rows