[TIME-63] timesheet report - add option to display aggregated report grouped by project and selectable field

Issue #63 resolved
Andriy Zhdanov created an issue

Requirement

We need an aggregated report like there is one already in the timesheet report, but with a second level of aggregation in addition to the dimension project. This would be very useful for the clearing of our external developers. With the aggregation, we get all the details we need in one view and don't have to look up the compensation keys separately.

Solution

I have checked out and extended the jira-timesheet-plugin trunk already.
The screenshots attached to this issue show the report dialog and a report with aggregated times on the field LB-Schlüssel. In addition to my own requirements, this could be a solution for issue #54 "[TIME-54] Add possibility to group worked hours by components in Timesheet report" too.

There are some constraints:

  • not all fields are resolved to their values, only the easy ones (TODO Tag)
  • for the field components ( issue #54 "[TIME-54] Add possibility to group worked hours by components in Timesheet report"), the component-names are concatinated to one string and not handled individually
  • the feature is only in the timesheet report, but not in the timesheet report excel view, not in the pivot report and not in the portlet
  • the field labels are not ordered (TODO Tag)

It would be great if you take over my code, so that I don't have to patch your plugin every time there is a new release. Attached to this issue, you will find a patch with my changes. Alternatively I can commit the changes directly into SVN. What do you prefer?

I'm not completely sure which version to set, because on the project site there is a download for version 1.8 already, but 1.8 version seems to be open, according to this Jira project, and there is no tag for 1.8 in SVN?!

The changes where tested on Jira Enterprise Edition, Version: 3.13-#330 on a Windows 2003 Server.

By aheinz/Alexander Heinz on Fri, 26 Jun 2009 08:59:24 -0700

Comments (7)

  1. Andriy Zhdanov reporter

    Hi Alexander,

    Thank you very much for your contribution, I will review your code, the problem is I've created code for issue #54 "[TIME-54] Add possibility to group worked hours by components in Timesheet report" also, but did not commit yet, hope it will merge some how, I will let you know.

    By azhdanov on Fri, 26 Jun 2009 10:03:27 -0700

  2. Andriy Zhdanov reporter

    Hi Alexander,

    I've looked through your changes, and it appears my code pending commit is something absolutely different.

    So, please commit your code into trunk, leave it 1.8 version as is. Please commit complied 1.8.jar also into the jars folder.

    Yes 1.8 is still open, I rather branch out versions because of incompatibilities between Jira versions. From other hand, 1.7 works with the same Jira versions as 1.8, but it is simplified one (as it was originally), and I still want to keep it simple, and at the same time I do not want to produce a bunch of branches for every set of features/customizations. Hope I've made it clear

    Thank you once more for your efforts!

    By azhdanov on Sun, 28 Jun 2009 09:25:41 -0700

  3. Andriy Zhdanov reporter

    r32936 | azhdanov | 2009-07-15 22:23:00 +0200 | 1 line

    issue #63 "[TIME-63] timesheet report - add option to display aggregated report grouped by project and selectable field": sort Group By Fields list, add possibility to specify possible fields (set jira.plugin.time
    sheet.groupByFields=fieldId,fieldName,...)


    r32863 | azhdanov | 2009-07-14 00:39:22 +0200 | 1 line

    issue #63 "[TIME-63] timesheet report - add option to display aggregated report grouped by project and selectable field": add support for multi valued custom fields, date and version types

    r32734 | azhdanov | 2009-07-10 00:32:35 +0200 | 1 line

    issue #63 "[TIME-63] timesheet report - add option to display aggregated report grouped by project and selectable field": display groupByField as additional column in timesheet report html and excel view; other mi
    nor corrections

    By azhdanov on Wed, 15 Jul 2009 16:35:07 -0700

  4. Andriy Zhdanov reporter

    Hi Alexander,

    Is it possible to change the time-frame each column represents (currently one day in the example screenshots) and have a column represent a week or a month (where the value would be accumulated time reported for the issue whereas the time the report was given must be within the time-frame boundary). So for example, if a column represents one month, all work logs given within the month will be accumulated for that column.

    Thanks

    By ofir.alon on Tue, 1 Nov 2011 08:18:36 -0700

  5. Andriy Zhdanov reporter

    Hi Ofir,

    sorry for the late response. I think it should be possible to aggregate the timeline in a per week/month/whatever way. Although that is a completely different usecase as the one described in this issue.
    I only provided kind of 'beta' code for this current issue. I suggest you open a new issue for your request. I think Andrew could answer your question in more detail.

    All the best
    Alex

    By aheinz on Mon, 20 Feb 2012 02:26:03 -0800

  6. Log in to comment