Working with charts in the Display editor

You can create charts for a visual query result set and manage them using the Display editor.

About this task

All charts that you create for a visual query result set are stored with this result set. You use the Display editor to manage the display modes of a query result set. The Display editor contains the following panes:
  • Result set
  • Layout structure
  • Display modes

The Result set pane displays all available result set columns regardless of the selected display mode. Query result columns are automatically grouped into three types: Category columns, Value columns, and Columns with aggregates. Category columns are columns that contain character data, and it is suggested that they are used for non-numerical data axes, such a the x-axis of a column chart. Value columns are columns that contain numerical data, and it is suggested that they are used for numerical data axes, such as the pie wedges of a pie chart. Columns with aggregates are copies of any columns to which the aggregations are applied. You can use the Result set pane to add groupings and aggregations to any column in the result set.

The Layout structure pane displays the specific layout structure of the selected display mode. Unlike the Result set pane, the Layout structure pane displays only the columns, groupings, and aggregations of the selected display mode. You can use the Layout structure pane to edit the individual layout structures the display modes.

The Display modes pane displays a list of available display modes. Each display mode has an independent layout structure and display settings. You can use the Display modes pane to add, delete, and edit the display modes of the given query result set.