EazyBI Get Issue Status from SubTasks

[Jack D]

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.

thanks

[Oskars Laganovskis]

Hi Jack,

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.

Kind regards,
Oskars / eazyBI support

[Jack D]

This shows the tasks as rows, i would like to show them as coloums?

for example..

Task Name	Assignee	Due Date	Sub Task 1 Status	Sub Task 2 Status
example 1	Jack	03/02/2010	Completed	Pending
Example 2	John	03/02/2022	Pending	On Going

[Jack D]

I'd like to show the status as highlighted below.

[Oskars Laganovskis]

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,
                [Issue.Sub-task].[Sub-task]),
    [Status].[Status].GetmemberbyKey(
        [Issue.Sub-task].CurrentHierarchyMember.Get('Status ID'))
     = [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 -
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Drillintomeasurebyanotherdimensionlevel.

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?

Kind regards,
Oskars / eazyBI support

[Jack D]

Hey any solutions? :X