Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

export the control chart in JIRA ?

Edited

hi all,

we use JIRA Software7.3 server. 

we use control charts and we want to see the underlying data in excel or any other readable format and not manually go through each point on chart.

we are looking to extract most of the underlying information like history, task, times ect. our goal is to see the wait time Vs work time when issues move through certain statuses.

 

is there a way to achevie this with a JQL or any other plugin. 

thanks,

2 answers

1 vote

Hello @sn , @Salvatore ,

This is an old post but since you are following this one...

There is still no export functionality for Control Chart but our team at OBSS built Time in Status app for this need with greater details and flexibility. It is available for Jira Server, Cloud, and Data Center.

Time in Status has many report types:

  • Status Duration and Assignee Duration reports allow you to see how much time each issue spent on each status or assigned to each assignee. You can also combine statuses into consolidated columns to see metrics like Ticket Age, Cycle Time, or Lead Time. You can even get SLA-like metrics this way. You can calculate averages and sums of those durations grouped by issue fields you select. (For example see the total InProgress time per Epic, or average Resolution Time per issuetype).
  • Status Count or Transition Count reports show how many times each status or each assignee was used. You can calculate averages and sums of those counts grouped by issue fields you select. (For example, average reopen count per issuetype).
  • 4 types of Date Reports show you the first/last transition dates from/to each status.

Time in Status can display its reports on its own reporting page, issue view pages, and dashboard gadgets (as data or charts in all).

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well. It works with both Company Managed and Team Managed (next-gen) projects.

Using Time in Status you can:

  • See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
  • Calculate averages and sums of those durations grouped by issue fields you select. (For example, see average InProgress time per project and per issuetype.)
  • Export your data as XLS, XLSX, or CSV.
  • Access data via REST API. (for integrations)
  • Visualize data with various chart types.
  • See Time in Status reports on Jira Dashboard gadgets and on issue view pages.

https://marketplace.atlassian.com/1211756

EmreT

Hi @Emre Toptancı _OBSS_ is it possible to get Standard deviation for cycle days in this app?

Best,

Laura

Like Salvatore likes this

Hi @Laura Ramirez

Yes, all numeric report types support average, sum, median, and standard deviation calculations.

Even better, you can group those calculations by one or more issue fields (including custom fields). For example, instead of getting an overall average, you can get averages grouped by issue type, or standard deviation grouped by component, etc. 

The following tutorial video shows an example of average calculation and grouping. It was prepared before the introduction of median and standard deviation calculation so no mention of them in the video but they are now supported too.

https://www.youtube.com/watch?v=Fv1WfZVVsPQ&list=PLozsWwplnns2J6mhEqLga7nE6VcTrwO7m

EmreT

1 vote

Hi,

There is a feature request for this at JSWSERVER-4288.  Please vote on it to add impact.  Once you vote on the issue and add any relavent comments for the developers you will be automatically notified when there is an update to the ticket.

Cheers,

Branden

thanks branden. can you suggest any plug-ins with this capability?

Any update on this one?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Marketplace Partner Spotlight: Fine Software

Happy New Year, everybody! What better way to kick off 2022 than with a new Marketplace Partner Spotlight ✨ This month, we're getting to know Daniel Franz, co-founder of Fine Software. Fine Software ...

398 views 2 15
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you