Request for information on data provided in exports from Jira Agile 6.3 and 6.4

I would like to know if it is possible to export the type of information needed

for Kanban Metrics used in the Cumlative Flow Charts and Control Charts.

I would like to export the amount of time a card resides in each column;

or the date and time stamp when a card is moved from one column to the next and

the column that the card is moved to each time a card is moved.

1 answer

1 accepted

0 vote

The information that these charts work from is all in the issue history. However, it's not explicitly stated in the history, it's calculated.

This isn't a real example, but let's say you move an issue from "open" to "closed". The date/time you created the issue is logged. The date/time you move the issue is logged. The. elapsed time between those is NOT logged, but you can always work it out from the two date/time stamps.

So, no, you can't export the data, but the information is there in the data. You'll need to export the basic data and work out the information from the data

Thank you for the speedy response.

Let's take a scenario...One of my team developers moves an issue from the analysis column and begins to develop it. After two hours he/she moves it to the test column. The tester finishes testing the issue and moves it to the verify column after 1 hour. The product owner then verifies the issue is complete and moves the issue to done after 30 minutes. I have not been in the system to watch all of this so all I can see is that the issue was updated when the issue was moved for the last time, which means I now have the Created Date/Time and the Updated Date/Time (when it was moved to Done). I have just missed everything in between and all of the time-stamps associated with each move.

My question is how I can have access to all of those timestamps without actually having to monitor the system in real time and recording each move as it happens. I hope this makes sense.

As I said, it's all recorded in the issue history. Look at the issue and use the history tab and you'll see a full set of date/time stamps.

You'll need to read that and do your calculations based on the data in there.

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Feb 15, 2018 in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

1,134 views 6 19
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot