Returns the set of descendants of a member at a specified level.
|Member_Expression||MDX expression that returns a member.|
MDX expression specifying a member level for the set.
|Set_Expression||MDX expression that returns set of particular level members|
For reports based on Jira data, function Descendants() is occasionally used to aggregate issues by some issue property which is not available as dimension or measure or to apply complex filtering criteria.
Following example would return issue count of issues created and resolved in the same period (complex filtering criteria).
See example report Issues created and resolved in period % in our demo account. The calculated measure Issues created and resolved in period uses the formula above to count resolved issues that was created in the same period.
Following example would return a count of completed Sprints. Function Descendants() allows to drill across Sprints and see the list of particular completed sprints based on this measure.
See example report Sprints and Story Points overview for project in our demo account. The calculated measure Completed Sprints uses the formula above.