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

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

Avatar

1 badge earned

Collect

Participate in fun challenges

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

Challenges
Coins

Gift kudos to your peers

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

Recognition
Ribbon

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!

Leaderboard

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
4,458,244
Community Members
 
Community Events
176
Community Groups

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

Atlassian Community Events