Grouping data in Jazz Reports
I would like to create a report that displays the number of defects by month.
With Eclipse BIRT, I can create a report that displays defects by time, i.e. I put TIMESTAMP in X-axis. Is it possible to group this time by month (i.e. in X-axis I have Jan, Feb, ...)? |
5 answers
Yes it is possible. You would have to edit the existing report using BIRT and re-deploy it to the server. How familiar are you with the BIRT report editor?
|
|
I did BIRT tutorial example. I did also the example described at this url: https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport.
I can create a report with BIRT that used WORKITEMS_SNAPSHOT to display defects (work items) by time. But I don't know group the time in X-axis to show Jan, Feb, ... in the X-axis instead of January, 12; January, 13 ... |
daclan wrote:
I did BIRT tutorial example. I did also the example described at this Hi Lan, Here's how to do what you want: Right-click on the chart in the report designer. Select "Select Data..." from the popup menu. Click on the button which has the hoverhelp "Edit Group and Sorting" (next to the "Category (X) Series" field). Select the checkbox for Grouping Enabled In the Unit, select "Months" and for Interval select "1". For Aggregate Expression it depends on what you're trying to do. You'll probably want either "Sum" or "Last". Hope this helps. james Jazz Reports Team Lead |
James,
How about grouping text. I know there is a type called 'text'. But when I group it there seems to be some data loss. For example, I would like to create a report for new work item count within a period with workitem categories on X-Axis. Since categories has entries in the NEW_WI_COUNT snapshot for each day, I see redundant values on X-Axis. So I would like to group the categories and somehow I'm losing the data by doing this. I must be doing something wrong. Please suggest. Thanks, Bharath |
|
On 8/14/2009 2:07 PM, littleheartb4u wrote:
James, Hi Bharath, Some things to check: On the "Format Chart" tab, make sure your X axis is selected as "Is Category Axis". On the "Select Data" tab, on the Y axis, make sure the Aggregate expression is set to Sum. Also have a look at both of the "Edit group and sorting" dialogs (for the Category (X) series as well as the Optional Y Series Grouping (if that applies to you). If this doesn't help, can you supply some more information? Thanks, james RTC Reports Team Lead |
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.