Report Visualization
Report visualization widgets show the actual result of the reports. The following are supported by the report visualization widgets:
• Pie
• Area
• Bar (simple, multi and stacked)
• Table
• Gauge
• Speedometer
The report visualization widgets have a common editor format.
The following table describes the most important fields of the editor for report visualization widgets. The actual fields used vary by chart type:
|
Field Name
|
Description
|
|---|---|
|
Data Source
|
The chart visualizes the result of this source report.
Some chart types have special requirements regarding the data source. For example, a multi bar chart can use only reports that are grouped by at least two fields.
Reports that cannot be used for the selected chart type are disabled in the list. Hints under the fields inform the user about the exact reason for disabled reports.
|
|
Grouping
|
The report visualization widgets accept only grouped reports as data sources.
In this field, select the grouping field to be used on the visualization.
|
|
Aggregation Function
|
If the report is aggregated by multiple functions (sum, avg, and so on .), this field is used to select the aggregated value to be shown on the visualization.
|
|
Display unit
|
High values can be rounded to hundreds, thousands, millions or billions to make the chart more straightforward.
|
|
Ordering
|
Defines the order in which the values are shown on the chart.
The ordering can be changed on both axes:
• When ordering by group name, the labels on the horizontal axis are in their natural order.
• When ordering by values, the labels on the vertical axis.are ordered by their corresponding value.
|
|
Horizontal/Vertical Axis label
|
The labels that are shown under the horizontal axis and beside the vertical axis.
|
|
No Group Text
|
The label used for values when a report is grouped by field, but a matching item has no values for the related field.
By default, the label for these values in the charts is No Group.
The default label can be changed in this field.
|
|
Chart Colors
|
A comma-separated list of colors either RGB codes ( #fff ) or color names
These colors override the default colors in the chart as follows:, the first chart segment is painted with the first color provided, the second segment with the second color and so on.
If there are more chart segments available than the number of colors provided, the same color is used in the chart multiple times.
|
|
Show Values
|
When this checkbox is selected,, the actual values are shown above the chart segments.
|
|
Value Label
|
Determines the label to show for the values in the chart: the value, a calculated percentage, or both. This field works together with the Show Valuesfield.  The following images show example displays for each option:       |
|
Show Legend
|
When checked, the widget adds a legend below the chart that explains the chart colors.
|
You can also add the following Report Visualization widgets:
CBQL Table
Codebeamer displays work items that are based on various cbQL tables.
Chart
Chart widgets unify the standalone report visualization widgets, making it possible to change the chart types after creating the widgets. The configuration options for each widget types remains the same.
Table
Table widget displays the result of reports in tabular form.
In addition to the fields described earlier, the table widget uses the following options:
• Columns —Select the columns of the report to be shown in the table.
• Column order—Change the order of the columns using drag and drop.
• Order by—Select the column to be used for ordering.
• Sort —The direction of the ordering (ascending or descending)
• Page size—The maximum number of items to be shown shown in the table. If the number of rows exceeds this value, then the table is paginated.