Context Filtering (Top/Bottom N Filtering with Another Field in "Context")

Angel Torres-Vargas

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

The Villages

Description (Required):

Sometimes, you need a top/bottom N filter to be in context of another field. For example, you want Top 10 Suppliers by Invoice Amount. Furthermore, you may need Top 10 Suppliers by another field (e.g. Aging Bucket, Supplier Type, etc.)

Use Case and Business Need (Required):

We have a Top 10 Suppliers by Invoice Amount viz. We also have an Invoice Count by Aging Bucket viz.

If we want to use the aging bucket viz as a filter for the top 10 suppliers viz, the aging bucket viz will filter out the top 10 to say 4 suppliers rather than adjust the filter to be top 10 suppliers by that aging bucket since the aging bucket field isn't in "context."

Enhancement Request / Service Request:

Add capability for context filters in grammar panel and for "Use As Filter" visualization property.