|MDX expression that returns set.|
|MDX expression that returns number.|
Design a set by listing individual members within curly brackets. For example, define a new calculated member for two highest priorities by listing priority members Highest and High:
See report example Issues created high vs low priority this and previous Year in our Demo account. The calculated member Highest & High in dimension Priority uses the formula above. The report uses this calculated member to compare issues with the highest and high priorities to other priorities.
The following example returns a set of standard (no sub-task) Issue types.
See report example Project progress % in our demo account. The calculated member Standard issue types in dimension Issue type uses the formula above. You can select this calculated member to filter and see the project progress for standard issues only.
The following example returns sprints from any board and orders them by start date: