Hello!
I’m creating Components overview table with data points on each component. I would also like to show oldest bug, latest Epic, highest prio issue, etc. The measure needs to output “KEY” of the issue so that it can be transformed into direct link with markdown.
I have this working, but I’m quite sure there must be a better way to do this.
The main problem of current solution is speed and also I would like to access and sort by any of the issue properties. For example to get the the number of days since last Closed Epic.
Current MDX:
Order(
Filter(
DescendantsSet([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Issue type] = "Bug"
AND
[Measures].[Issue status] <> "Done"
AND
[Measures].[Issues created]>0),
[Issue].CurrentMember.Get('Created at'),
ASC
).Item(0).Get('KEY')