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.
Thanks
Rafi
@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Sam Tsubota Is Enterprise Insights a separate license, how do I get that to access JA data for custom reports?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You have to purchase it separately. Reach out to your Atlassian enterprise advocate or partner to get more info and pricing.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.