Statistics Graph Drill Down Functions - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
wbc1492033894304.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software

Drill down into one or more graphs to see column statistics from the source data. Each column statistic selected will be entered into an editable drill down list automatically (a drill down window pops up as graphs are clicked). All columns in the list will be used as drill down criteria, resulting in a drill down data table containing rows belonging to all of the columns selected.

First, select one or more graphs from the Zoom View for drill down.

There are two ways to select graphs:
  1. Click on one or more graphs to add column statistics to the drill down list. Within each graph, select either the displayed box or one of the statistics listed below it, i.e., min, max, mean - SD (mean minus standard deviation) or mean + SD (mean by itself cannot be selected for drill down).
  2. Or, send values to the drill down list by selecting rows in the data selector, right-clicking on the rows and clicking on the ‘Drill Down’ pop-up menu item. In this case, the statistics min, max and mean +/- SD will be provided for the columns indicated in the selected rows.

The drill down list can be edited after graph selections are added, and saved for future reference. Note that the drill down list column labeled Col Row Count gives the number of rows containing a non-null value for the selected column (not the number of rows expected from the drill down for the indicated statistic).

Second, select the drill down tab on the Drill Down window to query the source data table. Rows from each column statistic selected will be returned and displayed in the drill down table.

In the header of the drill down display are options to “show graph data only”or “include related columns”. The tabular icon to the right of these two options in the header can be used to select up to 20 columns for display with the second option. By default, the first 20 columns when sorted alphabetically are displayed with the second option. The “sql” to the left of the tabular icon can be used to copy the SQL Where clause for the drill down query to the Clipboard for pasting into another text area or application.

Additional drill down features:
  • Save each list before creating a new one if it needs to be used again. After saving, a small icon appears next to the drill down icon in the upper right corner of the graph page. Clicking on the thumbnail will reload the saved list, enabling repeated reviews of the source data.
  • The saved list can be copied, edited by deletions or additions, and then replaced over the old list or saved as new. Clicking on the drill down icon reveals a list of default descriptive labels for the saved drill downs, which can be changed to something the user finds more meaningful.
  • Saved drill down lists can be deleted by right-clicking on thumbnail icons, or from the drill down label list.
Statistics Drill Down

The following right-click menu options are available from the display of drill down data rows after drill down is performed. They can be used to copy data to Microsoft Excel or to the Clipboard. When copying data to the Clipboard, columns are delineated by tab characters.
  • Export to Excel — All Rows
  • Export to Excel — Selected Rows
  • Copy (to Clipboard) — All Rows
  • Copy (to Clipboard) — Selected Rows

Note that drill down cannot retrieve source rows for a column that is renamed with an alias. Drill down will also not work properly when the table being analyzed is a volatile table created by a referenced analysis that doesn't create an output table or view.