The drill into feature enables you to drill into items in the Chart section that are resident in the Results section without having to return to reprocess your query or locate the item in Elements. Drill into items are automatically added as new label items.
The advantage of this feature is that it instantly enables you to add items to the data set to reflect temporary or hypothetical situations. You can always suspend or delete the item to return to the original chart display.
The extent to which you can drill into your data depends on how the original query was built, since Drill Into retrieves data from the Results section based on the table hierarchy of items. This feature does not enables you to interactively query the database.
Note: | You cannot drill into any items in a scatter or bubble chart because these types of charts use non-aggregated data. |
To drill anywhere into a chart:
Select one or more items for analysis and select Chart, then Drill Anywhere, and then Item.
Interactive Reporting redraws the chart drilled to the selected item. In the data layout, an item selected for drill-down is identified with a drill-bit icon.
Select Chart, then Drillup to return to the original view of your chart.
If no options are available in the Drill Anywhere menu, all Request items have been used in the data layout.