All eazyBI for Jira eazyBI for Confluence Private eazyBI

Children

Returns a set of direct children members of the current member.

Syntax

Member_Expression.Children

Arguments

Member_ExpressionMDX expression that returns a member.

Examples

Return the number of children issues for an issue

The following formula will return the number of direct children for each issue, for example, Standard type issues within Epic (without Sub-tasks).

Count([Issue].CurrentHierarchyMember.Children)

Count the number of Fix Versions in each Status

In this example, you can use the "Fix Version" dimension in Rows. Since the default hierarchy for this dimension is Project > Status > Fix Version, then at each of the levels you'll see the count of direct children. To see how many Fix Versions are there in each of the imported Projects, expand the "All Fix Versions" member to see the projects and then expand each individual project to see the count of Versions within each Status provided by this formula.

Count([Fix Version].CurrentHierarchyMember.Children)

Note that this will return only the number of Fix Versions imported into eazyBI account (Fix Versions that are associated with issues).

See also

  • Function Count() to count the number of elements in a set.
  • Function CurrentHierarchyMember returns the current member from the hierarchy that is currently used.