It's all about the answers!

Ask a question

Report items grouped by month of creation with report builder


Luiz Almeida (23015489) | asked Mar 01 '18, 1:51 p.m.

Hi friends,

I would like to create a report that brings me the total of workitens created in some project areas by month.
Example:

PA1
Jan - 23
Feb - 34
Mar - 54
PA2
Jan - 32
Feb - 65
Mar - 34
PA3
Jan - 99
Feb - 43
Mar - 22

Is it possible to make a report like that in Report Builder?
Do I have to make it with advanced SQL? If so, how do I do that?

Since now, thanks a lot for any tip.

Luiz Cesar.

One answer



permanent link
Rafik Jaouani (5.0k16) | answered Mar 01 '18, 3:04 p.m.
JAZZ DEVELOPER

Hi Luiz, if you are using 6.0.4 or later, you should add a custom expression field that extracts the month and year from the creation date. Also add a count field and use the calculated month/year to group by. This can be easily done without the use of advanced SQL.


Comments
Luiz Almeida commented Mar 01 '18, 3:51 p.m.

Thank you Rafik, but unfortunately I am using the 6.0.2.
I'm trying to do with advance SQL, but I had not success yet.


Luiz Almeida commented Mar 01 '18, 4:40 p.m.

Now I got it.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.