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
Wondering how can I report / retrieve data related to flow metrics : Epic/Capability/Feature lead time, throughput, Cycle time, Quality or say return on investment. Is there anyone who has been able to implement or retrieve such metrics out of Jira Align without using or buying additional connector/plugin.
Will appreciate the direction.
@Rafi Ahmad I wrote a community article on how to manually derive flow metrics from Jira Align views and reports.
@Rafi Ahmad Since you have multiple process steps in your process flow that represent active, you will probably need to take a sum of the average days of the active steps and then calculate the average.
For quality, you can get that through Jira or if you have Jira bugs syncing with Jira Align stories you can filter the Story grid view by Type = Defect and see the count of stories. You can track ROI using a Key Result for an Objective which can be linked to features.
@Sam Tsubota - Thanks for the clarification.
One a side note, I am hoping to put a power BI report for flow metrics together on a dashboard out fo Jira Align data which is backed up within our organization on a separate sql server database. what I am not sure is what is the data model or which coulmn sits under which table to fetch relevant data to calculate flow metrics. I am wanting to put a dashboard similar to this attachment so wondering how do I go about this, how do I know which tables to connect and which fetch column to fetch to put this dashboard together. Can you please help me out here or I can create a separate dedicated ticket (if you can share a link to crreate one).
@Rafi Ahmad The best way to accomplish this is with Jira Align Enterprise Insights which is a data warehouse for Jira Align. You will be able to connect Power BI to Enterprise Insights. It has tables with the data you need to be able a dashboard with flow metrics. Do you have Enterprise Insights?
@Sam Tsubota - We may not have enterprise Insights, I will still check.
But as I said, Jira Align data is backed up, so if I know which are those tables an dattributes or which tables need to be joined up to fetch those flow metrics, I can try. Is this something you can help me with?
@Rafi Ahmad Do you have an on-prem instance of Jira Align? It sounds like you do because if you have the cloud version you don't have the ability to backup your own data. If you do have an on-prem instance, I won't be able to help you because I don't know the Jira Align database schema. Enterprise Insights transforms the data in the Jira Align database to make it easily consumable to build custom reports.