All eazyBI for Jira eazyBI for Confluence Private eazyBI

TopCount

Returns a set of the top-N members from a set, optionally sorted by a numeric expression.

Syntax

TopCount(Set_Expression, Numeric_Expression1 [, Numeric_Expression2])

Arguments

Set_Expression

MDX expression that returns a set of members.

Numeric_Expression1

Numeric expression specifying the number of items from the top of the set to return.

Numeric_Expression2

Numeric expression (typically a measure) used to sort the set in descending order before picking the top items.

Examples

Top 3 assignees with most resolved issues

This formula can be used to return the names of the top assignees with the most resolved issues. When used with Time dimension Months or Weeks, it will show the names of top 3 assignees with the most resolved issues for each time period.

Generate(
  TopCount(
    [Assignee].[User].Members,
    3,
    [Measures].[Issues resolved]
  ),
  [Assignee].CurrentHierarchyMember.Name,
  ", "
)

See also