Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Report items grouped by month of creation with report builder

Questions
Tags
Users
Badges
LUIZ DE ALMEIDA
(230●1●63●93) 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.

0 votes

1 answer
2,827 views
0 votes

One answer

Permanent link
Rafik Jaouani
JAZZ DEVELOPER (5.0k●1●6) Mar 01 '18, 3:04 p.m.

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.

1 vote

Comments
LUIZ DE ALMEIDA
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 DE ALMEIDA
Mar 01 '18, 4:40 p.m.

Now I got it.

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019
× 7,495
× 481

Question asked: Mar 01 '18, 1:51 p.m.

Question was seen: 2,827 times

Last updated: Mar 01 '18, 4:40 p.m.

Confirmation Cancel Confirm