How to group report/gadget/filter results by month?

[Valentijn Scholten]

Hello,

I want to be able to generate reports that group the data by month.

More specifically I want know how many issues we have resolved each month, grouped by issue type.

It's easy to create the filter that selects the correct issues, but displaying them in the desired format is difficult.

Something like:

Month       Bug      Change     SupportRequest

January      1         4              5

February     5         3              3

etc. etc.

Currently the only report that does something like this is the Created vs. Resolved or Created Recently report.

This however doesn't provide any ability to group by issue type.

It seems that jira doesn't have much functionality to support grouping by month.

So I am considering the options to realize my goal:

- Use the (commercial) PowerReport plugin (https://plugins.atlassian.com/plugin/details/23616).

This costs money and generates another plugin which needs be to be compatible when upgrading jira versions.

- Create some sql queries myself

Not integrated with jira, needs updating when db model changes.

- Create a custom report (possibly based on the Created vs. Resolved report).

Does exactly what I want, but not much re-use.

- Create a customfield(type) YearMonth.

Seems an elegant and flexible solution.

So this YearMonth field would contain something like 2011-11 for november 2011, or maybe 201111 or 2011/11.

This would allow me to add a CreatedYearMonth field to issues, which I can use in a two-dimensional report/gadget.

It would also allow ResolvedYearMonth.

It can be used in all gadgets/reports, so provides some nice re-use in the future.

The questions for you:

- Am I missing some other possbilities (sometimes I feel I am overlooking some jira feature)?

- Anyone already has something created for this that we could share?

Thanks!

[Akeles]

Hi,

You might want to try Three Dimensional Date Gadget Plugin to see if i fits your requirements.

[Valentijn Scholten]

I can't select a comment as "the answer", but this plugin looks pretty well fit at first sight.

[tousifs]

Hi Valentijn Scholten,

The same approach i have done it via Report-module of jira

the besic approach was i have iterate the 12 months of year.[jan,Feb,March,April,----]

I have first date by default as 1 for each month . I have created small program where i can find the no of days in month i just take last day of specific month.

and while fetching result from JQL- Iterate the issue type:- Bug ,Change,Support Requst..

Take a Map defined key as Month and values as count of Bug,Change,Support Request as arraylist.

you could get the same out put what your getting.