Drilling in Visualizer

Visualizer makes it easy to drill down - and up - to display information at different levels of detail. For example, a user could click on a year in a report to view data for each quarter of the year, and click on the quarter to see data for each month in the quarter.

There are different ways that drilling is enabled for reports:

A Visualizer user can create one or more drill paths for a particular report. See Report-Level Drill Paths.

A Space Administrator can create drill paths and drill maps for use across the whole space. See Creating a Drill Map.

A Space Administrator can create a hierarchy in the dimensional model of the space. See Creating Hierarchies.

The pre-configured Time attributes are already set up for drilling. See Time Attributes and Time Series Measures.

Visualizer displays a Drill icon to indicate that an attribute in the Chart Builder can be drilled to show a different level of detail.

Tips:

  • Drill-down is not supported for pie charts.
  • If you plan to include a Visualizer chart report in a new Dashboards 2.0 dashboard, be aware that a drill-across at the dashboard dashlet level overrides a drill-down defined at the chart report level.  

To drill in Visualizer

1. Add a measure and an attribute configured for drilling. For example, Revenue by the built-in Year attribute. The Chart Builder shows the Drill icon.
2. Click the Drill icon. Visualizer shows the next level attribute in the Subject Area.  

3. You can click on the drilldown attributes in the Subject Area to swap out the attributes in Chart Builder. Visualizer will keep showing the next level down until the last attribute is reached.
4. To interact with the drillable chart, click on a chart component to start the drill down. For example, click a Year column to see the chart change from Year to Year/Quarter. At the top of the chart you see the breadcrumbs of the drill path. Chart Builder also shows the updated Filters.
5. Keep clicking on the chart to continue drilling. The breadcrumbs update. You can click a breadcrumb to go back to a previous view.
6. If multiple drillpaths, hyperlinks, and drill maps are created for the same item, you can select the drill option from a drill menu to display the multiple drill selections.
For tables and crosstab reports, you can access the drill menu by left-clicking on the item in the report.

For non-table chart types, right-click or secondary-click on the item in the report to access the drill menu. Alternatively, you can access the drill from the Chart Builder.

7. Click Save .
8. Add the report to a dashboard. See Adding a Visualizer Report to a Dashboard.

Learn More

Visualizer Report Basics

Working with Chart Reports

Working with Tabular Reports