How to count the number of Subtask per status?

Questions & Answers
1

Hello,

I am currently trying to calculate the the following table with EazyBI, and I do not manage to get the proper values calculated. Could you please suggest the proper & best way to acheive this ?

First use case :

  • column : list of issues
  • measure(s) : count of subtasks (of the issue) in each statuses, per issue.

Second use case :

  • column : list of issues
  • measure(s) : percentage of subtasks (of the issue) in each statuses, per issue.

Thanks in advance

2

eazyBI has a default measure “Sub-tasks created”. This measure counts all sub-tasks for any issue. However, you cannot split this count by sub-tasks statuses as a parent issue attributes work with this measure.

I would suggest using an Issue Sub-task hierarchy for this report.
You can use a default measure Issues created and use Issue type dimension on Pages and filter out Sub-tasks only.

You would like to create a new calculated measure to get % of Issues split by Statuses with some calculated measure:

[Measures].[Issues created]
/
([Measures].[Issues created],
[Status].CurrentHierarchy.Defaultmember)

Here is a report example:

report example 1
report example 1.png2294Ă—960 309 KB

Daina / support@eazybi.com

1 Like