Using a stacked bar chart for comparing different series of results
A stacked bar chart compares the results for different sets of results. The following example is for a stacked bar chart for all assignees in an incident group. The details of creating a bar chart are provided in the BIRT online help.
- In BIRT Report Designer, create a basic new report.
- Configure the data set for the report by adding the Status, Assignee Groups, Assignee, and Incident Number fields on the Query tab.
- On the Layout pane, right-click in the report layout and select Insert > Chart.
- On the Select Chart Type tab of the New Chart dialog box, select Bar as the Chart type, and Stacked Bar chart as the Subtype.
- Click the Select Data tab, and complete the following steps:
- From the Use Data from list, select Data Set.

- Under In the Value (Y) Series, configure at least two series of data for Status by using the Expression Builder.
Optionally, configure the Aggregate Expression field to Count. - Under In the Value (X) Series, configure a series of data for Assignee Groups by using the Expression Builder.
- From the Use Data from list, select Data Set.
- Preview the report (save, run, and close the report).
If the bar chart needs adjustment, click the Binding tab in the Property Editor for the chart and review the data binding settings.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*