Drill down into one or more frequency counts from one or more columns to see source data rows. Each count category selected will be entered into an editable drill down list automatically (a drill down window appears as categories are selected). All categories in the list will be used as drill down criteria, resulting in a drill down data table containing rows belonging to all of the categories selected. There are two ways to select frequency categories for drill down:
First, select frequency counts that target the source data of interest. Multiple counts can be selected from different graphs to build up composite views of source data.
- Click on one or more bars to add column categories to the drill down list.
- Or, send column categories 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.
The drill down list can be edited after graph selections are added, and saved for future reference.
Second, select the ‘drill down’ tab on the Drill Down window to query the source data table. Filtered rows (rows that fit the drill down criteria) will be returned and displayed in the drill down table. In addition to the graph data, all related rows from the source table can be viewed as well.
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.
- 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.
- 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. Also, drill down will not work properly when the table being analyzed is a volatile table created by a referenced analysis that does not create an output table or view.