Nsryjdtyk

For a customer I need to create monthly reports that shows, among other things, how much time an issue is spending in the different statuses (TO DO, In progress, Closed etc.). More specifically, the customer wants to see, how long it takes from the time when they create the issue, and to the time when we "take" the case and start working on it.

I was quite surprised to find out that you can not get this in Jiras default reporting tools. I have searched for relevant Add-Ons, but most reporting tools is very pricy, and I'm not even sure whether they offer this functionality or not. Isn't this a normal metric to want from a report?

However I found David Bevins Jira Rest Client Dot Net api. Unfortunately this api doesn't give me the opportunity to extract the relevant data (timestamps, activity etc.)

So now I have turned to Jiras rest api, and I am trying to set up a program in .NET to do it. This guy did exactly the same. As you see in his SO question, the returned JSON is a mess. Collecting all the right data will require a lot of work. So before I go further I want to know if anyone has done this before and how you did it?

Any help is appreciated.

Jira has not this option by default and there is not simple way to solve it programatically.

However it is possible to get this data (but you have to use probably 3 or 4 tables from database):

1) create jira add-on and parse data there

2) use Home Directory Browser (https://marketplace.atlassian.com/plugins/info.renjithv.jira.plugins.sysadmin.homedirectorybrowser/server/overview) for getting data and then parse it in you own program

On Atlassian Marketplace is a plugin exactly for this functionality and it works very well, there are filters, time range and some export options:

https://marketplace.atlassian.com/plugins/com.obss.plugin.time-in-status/server/overview

you can tried the trial version for free.

There is a library I have created some time ago to pull metrics from Jira:
https://bitbucket.org/kaszaq/howfastyouaregoing

From what I understand you are looking for a cycle time of issue in given statuses. I think this example should help you:

package pl.kaszaq.howfastyouaregoing.examples;



import com.google.common.collect.Sets;

import java.time.LocalDate;

import java.time.Month;

import java.util.HashSet;

import java.util.OptionalDouble;

import java.util.SortedMap;

import pl.kaszaq.howfastyouaregoing.agile.AgileClient;

import pl.kaszaq.howfastyouaregoing.agile.AgileProject;

import static pl.kaszaq.howfastyouaregoing.agile.IssuePredicates.hasSubtasks;

import pl.kaszaq.howfastyouaregoing.cycletime.CycleTimeComputer;



public class CycleTimeExample {



    public static void main(String args) {

        AgileClient agileClient = AgileClientProvider.createClient();

        runExample(agileClient);



    }



    private static void runExample(AgileClient agileClient) {

        LocalDate from = LocalDate.of(2011, Month.JULY, 1);

        int daysAverage = 30;

        LocalDate to = LocalDate.of(2014, Month.JANUARY, 1);

        AgileProject agileProject = agileClient.getAgileProject("MYPROJECTID");

        String cycleTimeStatuses = {"In Progress", "Ready for Testing"};

        final HashSet<String> finalStatuses = Sets.newHashSet("Closed");



        SortedMap<LocalDate, Double> cycleTime = CycleTimeComputer.calulcateCycleTime(agileProject, hasSubtasks().negate(), finalStatuses, cycleTimeStatuses);



        System.out.println(

                "tCycle time for issues that do not have sub tasks in hours");

        for (LocalDate k = from; !k.isAfter(to); k = k.plusDays(daysAverage)) {

            OptionalDouble valueOptional = cycleTime.subMap(k.minusDays(daysAverage), k.plusDays(1)).values().stream()

                    .mapToDouble(val -> val)

                    .average();

            if (valueOptional.isPresent()) {

                System.out.println(k + "t" + valueOptional.getAsDouble());

            }

        }



    }

}

https://bitbucket.org/kaszaq/howfastyouaregoing/src/5a2ab64e2304f22b3e82beaf427487f8a8a8e1e7/howfastyouaregoing-examples/src/main/java/pl/kaszaq/howfastyouaregoing/examples/CycleTimeExample.java?at=default&