I’m trying to build a Version report and I’m facing some difficulties.
In our Jira projects we have issues without sub-tasks where time (Original Estimate & Remaining Estimate) is tracked directly and issues with sub-tasks where time is tracked at sub-tasks level.
I’ve selected Project and Fix Version dimensions as Pages.
Project is used to select an overall Project or a Component inside a Project (in big project Component is used to define a team).
Fix Version is used to select the version for which I want to build the report.
I’ve selected Time dimension as Rows with Week selected as Hierarchy level members.
Then, I’ve created a calculated measure Time within version (formatting as Integer) to filter time to keep only the version time frame on the Timeline chart:
[Measures].[Version start date],
[Measures].[Version release date] )
The 4 measures I want to display for each week are:
Cumulative hours spent with sub-tasks within version
Here, I’ve created the corresponding calculated measure using the following formula and it works well:
[Measures].[Time within version] = 1
[Measures].[Hours spent with sub-tasks]
Remaining estimated hours with sub-tasks within version
Release guideline (ideal remaining estimated hours to reach version end date)
Original estimated hours with sub-tasks within version
I’ve tried different solutions for these 3 measures but without success.
So, could you please help me for these 3 measures.
Thanks in advance.