Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Jira Align - Flow Metrics

Hi Community. 

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.



1 answer

1 vote
Sam Tsubota Atlassian Team May 02, 2022

@Rafi Ahmad I wrote a community article on how to manually derive flow metrics from Jira Align views and reports.

Thanks @Sam Tsubota , Should I assume sum of all avg. time from all active states on my end for avg. active time as I don't have just one state as on your example?

Also would you know how to retrieve info. about Quality or say return on investment etc. 

Like Allan Maxwell likes this

@Sam Tsubota  - Following up to check if you have an update for me

Sam Tsubota Atlassian Team May 05, 2022

@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).PBI - JA.JPG

Sam Tsubota Atlassian Team May 08, 2022

@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?

Sam Tsubota Atlassian Team May 09, 2022

@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. 

@Sam Tsubota - JA is in SAAS at our end. 

Sam Tsubota Atlassian Team May 09, 2022

@Rafi Ahmad You will need Enterprise Insights. You won't be able to access your Jira Align instance's database directly since you are on Jira Align cloud. 

@Sam Tsubota Is Enterprise Insights a separate license, how do I get that to access JA data for custom reports?

Sam Tsubota Atlassian Team May 09, 2022

You have to purchase it separately. Reach out to your Atlassian enterprise advocate or partner to get more info and pricing.

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events