Access specific element of "dataSetRow" array

I am new to BIRT and just started using it to create some reports using ClearQuest. I am trying to chart some details by owner. However for each owner on the x-axis of the chart is aggregating all records (not only the records that belong to that owner).

Need to add a condition to the data set that is aggregating the records to only count the record if the owner of the record is the same as the owner currently being looked at on the x-axis. ("row.__rownum" is the current row number which I believe would equate to the current owner in dataSetRow["Owner"] but I could be wrong)

row["Owner"]==dataSetRow["Owner"],row.__rownum

Find more posts tagged with

Comments

Monma

Could you please specify what chart you are trying to build. And a description of you dataset and queries. Something does not sound right in what you are trying to do. Your query should be built to only display the information for the owners that you are plotting. You seem to be making things harder than they need to be.

craigg

I am plotting number of defects and enhancments on the Y axis - and owner on the x-axis.

The Y axis is broken down into two series:
- count of records of type Defect
- count of records of type Enhancment

The X axis is simply "row["Owner"]

The chart works when the query is only for one person (e.g. all defects and enhancments in the dataset are owned by one person)

However - when I use a dataset that has records by mutliple owners it put the count of all the records against every owner (e.g. There are 5 defects and 2 enhancements spread over 3 owners - the report shows all three owners having 5 defects and 2 enhancments each instead of showing the first owner having 3 defects & 1 enhancment, the second owner having 2 defects, and the third owner having 1 defect)

I figure I need to refine the dataset for the y axis from a count of all records of type "Z" to be a dataset of all records of type "Z" and owner equals owner on x axis.

cypherdj

The value (Y) series should probably be a count series and the category (X) series should be the owner.

Can you send the data set query that you are binding to your chart, and a screenshot of the "Select data" tab in your chart?

This should help in guiding you to build your chart appropriately.

Regards,
Cedric

craigg

Talk about wierd - I am now having a different behaviour in my report (but closer to what I am looking for). The report is now showing the correct cumulative number of records by owner - but it is counting both type of records against each record type.

I have two aggregate data bindings configured - one for records of type Defect and one for records of type EnhancementRequest. You can see how they are setup in the screenshot but to summarize

"Defects" = count(row["record_type"]=="Defect")
"Enhancements" = count(row["record_type"]=="EnhancementRequest")

series 1 on the y-axis is a Count of row["Defects"]
series 2 on the y-axis is a Count of row["Enhancments"]

However - the report is showing the total count of both series for each series (e.g. if a userid has 1 Enhancement and 3 Defects the chart show 4 Enhacements and 4 Defects).

Any and all help is appreciated.