Charting Answerset data - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Charting Answerset data

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.

To create a chart

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.