) in the table
title bar to display a pivot table.The Ad Hoc Data Discovery table displays the metric data you select, broken down based on the dimensions you select. The table contains a column for each of the dimensions and metrics. |
In this topic |
The default table format is a straight table, but you can use the Fast
Change icon () in the table
title bar to display a pivot table.
The data displayed in the Ad Hoc Data Discovery table is affected by filter values selected on other analytic tabs in Capture Analytics. For example, if you select one project manager on the Current Pipeline tab, the Ad Hoc Data Discovery tab only displays data for that project manager if you select the Project Manager dimension.
To start your ad hoc data discovery with no
filters, click 
on the toolbar
and then select your dimensions and metrics.
You can filter the contents of the table while working on the Ad Hoc Data Discovery tab by selecting a cell in the table:
If you click a cell in a column that contains dimension values, the table is filtered based on the selected value. If multiple rows have the selected value in that column, all of those rows are selected.
If you click a cell in a column that contains metric data, the table is filtered for the combination of dimension values in that row. Generally that focuses the table on that row only.
If you focus the table by clicking a cell, Capture Analytics applies the same change, as appropriate, to all other analytic objects.
Click 
to display the table at its
maximum size so you can read it and interact with it more easily. Click
to restore the table to its original size and location
on the tab.
In the pivot table format, click 
in a
table cell to expand that item to reveal detail at the next level. To
collapse the detail for a table item, click 
in that
table cell. To expand or collapse detail for all items in a column, right-click
in that column, and click either Expand
All or Collapse All on
the shortcut menu.
In the straight table, you can sort the data based on values in any of the columns. In the pivot table, the sorting options are not available.
To sort the table based on the values in one of the columns, double-click the column heading for that column.
To change the sort order from ascending to descending or from descending to ascending, double-click the column heading of the current sort column.
For both straight and pivot tables, you can use the mouse to drag and drop columns to change the column order and, as a result, how data is grouped. This is a particularly effective data discovery tool when applied to the pivot table view.
Click 
to send the data underlying
the table to Microsoft Excel. More...
In addition to the actions described above, you can also do the following:
Print the table.
Email the table.
Export table data to a CSV file.
Attach a note to the table.
For more on these actions, see Print, Email, or Export Analytic Data and Attach Notes to Analytics.