Grouping data in Jazz Reports

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
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 ...

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,

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

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