Measure : time remaining on Sub-Task of Story and Task only

Questions & Answers
1

Hi !

I would like to display on the same report the estimated time remaining for subtasks from stories only and for subtasks from stories and tasks.

How can I do it?

image
image894×491 27.7 KB

Thanks !

2

@B0gs

Try defining the new linked field dimension “Parent issue type” using this formula in advanced settings:

[[jira.issue_link_field_dimensions]]
name = "Parent Issue Type"
source_dimension = "Issue Type"
issue_id_column = "subtask_parent_id"
group = "Linked issue dimensions"

See more about this feature here:
https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/issue-link-field-dimensions

Then add the “Parent issue type” dimension and “Issue type” dimension as page filters and select correct issue types for parent and sub-tasks.

Martins / eazyBI support

image
image1674×1012 134 KB

1 Like
3

Thanks.

But, in the same table, is it possible to have two columns :

  • first column : remaining estimated hours history for subtasks of Story
  • second column : remaining estimated hours history for subtasks of Story and Task

I don’t have permissions to define a new linked field dimension.
Is it possible to do this with a new calculated measure ?

4

@B0gs

Yes, in that case, create two calculated measures:

(
[Measures].[Remaining estimated hours history],
[Parent Issue type].[Story]
)

And

Aggregate({
[Parent Issue type].[Task],
[Parent Issue type].[Story]
},
[Measures].[Remaining estimated hours history],
)

And then remove the “Parent issue type” dimension from the report as it is hardcoded in the calculations.

Martins

5

Thanks.

I don’t have access to the advanced settings.
So I can’t define the new linked field dimension “Parent issue type”.

Is it possible to do this directly in the calculated measures without the linked field dimension ?

6

@B0gs
The workaround may lead to a very slow report.
Please reach out to your Jira system administrator who should have access to advanced settings.

Martins / eazyBI