export the control chart in JIRA ?

[sn]

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,

[Emre Toptancı _OBSS_]

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

[Laura Ramirez]

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

Best,

Laura

[Emre Toptancı _OBSS_]

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

[somethingblue]

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

[sn]

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

[Salvatore]

Any update on this one?