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.
A Space Administrator
can create a hierarchy
in the dimensional model of the space.
The pre-configured Time attributes are already set up for drilling.
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. |