To create an ad-hoc chart based on the displayed data, you can use the Chart option.
You can define one chart per saved report. Once defined, you can switch between the chart and report views using links below the Search bar. Options include:
-
Chart Type - Identifies the kind of chart. Select from horizontal bar chart, vertical bar chart, pie chart, or line chart.
-
Label - Enables you to select the column to be used as the label.
-
Axis Title for Label - Title that appears on the axis associated with the column selected for Label. This title is not available for a pie chart.
-
Value - Enables you to select the column to be used as the value. If your function is COUNT, a value does not need to be selected.
-
Axis Title for Value - Title that appears on the axis associated with the column selected for Value. This value is not available for a pie chart.
-
Function - An optional operation to be performed on the column selected for Value.
-
Sort - Allows you to sort your result set.
The picture below shows the example of a chart that displays the total amount in € that each buyer is responsible for.
And this is the result:
You can use the buttons in the Search bar to toggle between the report view and the chart view. To delete the chart definition, click Edit Chart to open the Chart box, and click Delete.