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
I need to run a report where it can show the Key Results count and it's completed status in % - followed by the features count and it's completed status in %, then followed by the Stories count and it's completed status in %
There is Key Results 1 which has 3 features viz. Feature 1, Feature 2 & Feature 3.
Feature 1 has 8 stories. 4 are closed, 2 are in progress & 2 are in new state
Feature 2 has 10 stories. 6 are closed, 3 are in progress & 1 is in new state.
Feature 3 has 15 stories. 6 are closed, 5 are in progress & 4 are in new state
There is Key Results 2 which has 3 features viz. Feature A, Feature B & Feature C.
Feature A has 18 stories. 7 are closed, 6 are in progress & 5 are in new state
Feature B has 20 stories. 11 are closed, 6 are in progress & 3 is in new state.
Feature C has 25 stories. 14 are closed, 9 are in progress & 3 are in new state
The report should show the Key Results count and it's completion status in %, followed by Feature’s count and it's completion status in % and then followed by Story’s count and it's completion status in %
Please help in creating the custom hierarchy for the above.
Your help is much appreciated.
The first step to analyze the hierarchical relation and completion of issues is defining the issue hierarchy in eazyBI.. If you use Advanced Roadmaps, the issue hierarchy will be created automatically by importing the "Parent Link" field. Please see more details about defining an additional issue hierarchy on the eazyBI documentation page - https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/additional-issue-hierarchies. If you already have that covered, you can skip this step.
With the issue hierarchy defined and imported, you can select the Issue dimension in report rows and select the hierarchy. eazyBI will sum up all measure values to the top levels. Please see an example below with the Advanced Roadmaps hierarchy in the Issue dimension:
You can then calculate the total completion by dividing the number of resolved issues by the number of created issues. The formula could look similar to the one below:
CASE WHEN [Measures].[Issues created] > 0
Let me know if you require more details or have any questions.
Roberts // email@example.com
Hi @Thejaswi S N ,
For eazyBI for Jira Cloud, an additional step is required. Please see the instructions here - https://docs.eazybi.com/eazybi/data-import/data-from-jira-apps/advanced-roadmaps-custom-fields#AdvancedRoadmapscustomfields-JiraCloud. After that, you can find the Advanced Roadmaps field "Parent Link" field in the eazyBI import options "Add-ons" tab.
Roberts // firstname.lastname@example.org
If you are open to 3rd party solutions we've created an automated solution for this at minware.
Our predictive roadmap automatically shows dependencies, and weighs weekends. You can roll down from epic to subtask for a detailed view of WIP/completed work/planned work.
Since our dashboards are created by uniquely combining version control, ticketing, and calendar data we can provide full transparency in one plug and play solution.
We offer a free trial, if you would like to check it out please let me know!
Disclaimer: marketplace partner