You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Hello new to eazybi wanted to know the possibility of fetching the status of subtasks. for example:
Task Name | Assignee | Issue Link Status 1 | Issue Link Status 2 etc.
to show an overall picture of the project.
The easiest way of accessing sub-tasks is to use sub-task hierarchy in the Issues dimension.
You can then see the parents and their children with the relevant properties displayed.
You may select the project level from the sub-task hierarchy and expand it down to the sub-task in the report area.
That might give you the following view of the report.
Displayed levels - project, task, and underlying sub-task.
I also added a few properties to display.
Let me know if this is what you were looking for or describe what you would like to see in more detail.
Oskars / eazyBI support
Hi @Jack D ,
If I understand you right - you would like to see each task on a separate row and sub-task statuses on the columns.
Although it is possible to create a separate measure that would retrieve the status for the n-th sub-task, that might not be the preferred way as it would be hard-coded and might miss details of new sub-tasks once their number exceeds the initially planned.
I would suggest displaying the number of sub-tasks in each status with the possibility to drill into them for details.
You might create a calculated measure with the following MDX expression in the Measures dimension.
Sum( Filter( Descendants([Issue.Sub-task].CurrentHierarchyMember,
= [Status].CurrentMember), [Measures].[Issues created] )
After adding this measure to the report, you could drill into this measure by the Status dimension.
You might read more about drilling into a measure by another dimension here -
After that, you might enable Hide empty columns from the report toolbox to only display statuses that are relevant to the report context.
The final look of the report would be like this.
You might also drill into the figures to see more details on the sub-tasks of a specific task in a particular status.
Would this solution fit your needs?
Oskars / eazyBI support