Chart to track story bugs' time spent vs development time

[polina_valcheva]

Hello,

I'm trying to create a dashboard chart showing stories with specified target version on x-axis and the sum of time spent on story bugs(issue type) & the sum of of time spent on technical tasks (issue type) in split bar on y-axis. 

Any guidance on how I can achieve this would be greatly appreciated. 

Many thanks! 

[David Leal]

You can try Jira Cloud for Excel/Google Sheets, they are Atlassian official plug-ins and they are free.

You can get the field Days in Status to get durations on a given status. Check for example: Jira Cloud for Google Sheets Add-ons Days in Status field pattern and returned value for duration.

You need to know the status ID, not the status name (put this URL in your browser)

https://<YOURSITE>.atlassian.net/rest/api/latest/issue/<ISSUEKEY>

Here is an example Days in Status field possible value:

3_*:*_1_*:*_18206_*|*_10000_*:*_1_*:*_2103302_*|*_10275_*:*_1_*:*_62551162_*|*_10088_*:*_1_*:*_11796778_*|*_10087_*:*_1_*:*_2577772_*|*_10001_*:*_1_*:*_0

It indicates for each status ID how many times it passes through a given status and the duration in milliseconds on a given status. For example, for status ID 3 (this is IN PROGRESS status in my Jira instance), it was 1 time and the duration was 18206 (if you divide by 86400000 you get the number of natural days in status). Each number is delimited by _*:*_ and each record (each status) is delimited by _*|*_.

Next, parse the information you get from this field. You can check this link: Parse Days in Status field from Jira Cloud for Google Sheets, on how to do it for Google, for Excel it is similar.

Finally, build your report in Excel/Google based on the data you got from Jira. Worth mentioning that this field is only populated if the issue was closed (reached the Done status), for work-in-progress issues, this field is not populated, so it serves to do a post-mortem analysis only.

I hope it helps,

David

[Mehmet A _Bloompeak_]

Hi @polina_valcheva

Welcome to the Atlassian Community!

You can try Reports - Charts and Graphs for Jira Dashboard app developed by our team to create various reports, charts and graphs for your Jira projects.

Here is our live demo dashboard where you can see and modify sample reports and play with them. For your case, you can have a look at the report below.

With this app;

• You can create custom, flexible and colorful bar charts and table views for any data you want/need. As data source, you can choose Projects or Saved Filters or Advanced (JQL).

• You can set X axis to be any parameter like Created(month), Assignee, Sprint, Fix Versions etc.
• You can set Y axis to be any parameter like number of issues, sum of remaining estimates, average of story points etc.
• You can group your data on any field (Sprint, Status, Assignee, Component, Project etc.) you want.
• You can choose various date ranges like All Time, Last Year, Last 3 Months, Last 6 Months etc.
• You can modify existing Segments or add new segments.
• You can order the results by drag and drop.

For more detail, you can have a look at Reports - Charts and Graphs for Jira How to Videos and How to Create Custom and Flexible Reports, Charts and Graphs in Jira article.

If you are looking for a completely free solution, you can try the limited version Reports - Charts and Graphs for Jira Dashboard Free.

Hope it helps.