Original Estimates vs. Actual

[Fabio Lanza]

Is there a way in JIRA (at the project level), create a view, report, graph…anything that will show me “Original Estimates vs. Actual” story points delivered?

Our Jira version is 4.4.5.

[Onkar Ahire]

This code will help you to develop reports,graphs of Orignal estimates.

private String getOriginalEstimateString(Issue issue)
{
     long estimate = -1;
     if (issue != null)
     {
            if (issue.getEstimate() != null && issue.getOriginalEstimate() != null)
            {
                estimate = Math.min(issue.getOriginalEstimate().longValue(), issue.getEstimate().longValue());
            }
            if (estimate != -1)
            {
                return DateUtils.getDurationString(estimate, getHoursPerDay(), getDaysPerWeek());
            }
        }
        return null;

    }
private int getHoursPerDay()
{
     return Integer.parseInt(ComponentAccessor.getApplicationProperties().getDefaultBackedString(APKeys.JIRA_TIMETRACKING_HOURS_PER_DAY));
}
private int getDaysPerWeek()
{
       return Integer.parseInt(ComponentAccessor.getApplicationProperties().getDefaultBackedString(APKeys.JIRA_TIMETRACKING_DAYS_PER_WEEK));
}

[steven.schafer]

This is a great code. Where do I put this snippet of code at? I'm fairly new to JIRA and unsure where to put this code snippet. Thanks. Steven

[Onkar Ahire]

Hi Steven,

It depends which plugin module are you implementing, I use this code in report generation.

map.put("orignalEstimates",getOriginalEstimateString(issue));

rendered in *.vm

FYI another useful method I used for report generation to calculateTime and diffs, might helpful

public static long compareTwoTimeStamps(java.sql.Timestamp currentTime, java.sql.Timestamp oldTime)

	{

	     long milliseconds1 = oldTime.getTime();

	     long milliseconds2 = currentTime.getTime();

	     long diff = milliseconds2 - milliseconds1;

		 long diffSeconds = diff / 1000;

		 return diffSeconds;

	 }

	public static String calculateTime(long seconds) 

	 {		

		 int day = (int) TimeUnit.SECONDS.toDays(seconds);

		    long hours = TimeUnit.SECONDS.toHours(seconds) -TimeUnit.DAYS.toHours(day);

		    long minutes = TimeUnit.SECONDS.toMinutes(seconds) -TimeUnit.HOURS.toMinutes(TimeUnit.SECONDS.toHours(seconds));

		    long second = TimeUnit.SECONDS.toSeconds(seconds) -TimeUnit.MINUTES.toSeconds(TimeUnit.SECONDS.toMinutes(seconds));

		    if(day==0 && hours==0 && minutes==0)

			       return second+" sec";

		    if(day==0 && hours==0)

			       return + minutes + " min "+second+" sec";

		    if(day==0)

			       return hours+" hrs "+minutes+" min "+second+" sec";

		    return day+" day "+hours + " hrs " + minutes + " min "+second+" sec";

	 }