Charting Answerset data - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product

SQL Assistant

Release Number

15.10

Language

English (United States)

Last Update

2018-10-07

dita:id

B035-2430

lifecycle

Product Category

Teradata Tools and Utilities

Charts can be created based on the data within an Answerset grid. By default, the chart appears in a new tab within the same Answer window. An option exists on the Chart Definition dialog box to display the new chart in a separate window. This would provide the option to view the chart and data at the same time.

1 Right-click in the Answer window and click Chart ... , orClick the button on the Answerset toolbar.

2 On the Chart Definition dialog box select the Chart Type you wish to display

3 Enter or verify the From / To Row number for the rows to be plotted

4 Select or verify the Column(s) whose data you wish to chart

5 Select or enter any additional options for the chart, and press OK

Table 22: Chart Definition Dialog Box
Control	Description
Chart Type	This drop down list allows you to select the type of chart you wish to create. The picture below shows a simple example. The default is a line chart.
Horizontal	Draw Horizontal bars rather than vertical Columns. Used for Bar types only. The default is cleared.
Rectangular	Draw rectangular bars rather than cylindrical bars. Used for Bar types only. The default is cleared.
3D	Draw a 3D chart. The default is selected. Note: A chart can also be changed to 2D by changing its rotation and elevation
From Row	This specifies the first row to be included in the data range to be plotted. This value is pre-populated if a block of cells is currently selected.
To Row	This specifies the last row to be included in the data range to be plotted. This value is pre-populated if a block of cells is currently selected.
X Axis Labels	This column provides the data labels for the X Axis. Select <RowNumber> to use the row number instead of a data column.
Data Columns	Select one or more numeric columns whose data you wish to chart. Only one column can be selected if the Chart Type is Pie. The highlighted columns are pre-selected if a block of cells is currently selected.
X Axis Title	If entered, this text appears below the X axis labels
Y Axis Title	If entered, this text appears to the left of the Y axis labels.
Chart Title	If entered, this text appears above the chart.
Display Chart in a new window	Select this box to display the chart in a new window. The default is checked if the Answerset Mode is Each Resultset. Otherwise, it is cleared.