Adding Drill-Downs to Visual Data in Amazon QuickSight

All visual types except pivot tables offer the ability to create a hierarchy of fields
for a visual element, and then to drill down to see data at different levels of the
hierarchy. For example, you could associate the country, state, and city fields with
the
X axis on a bar chart, then drill down or up to see data at each of those levels.
As you
drill down each level, the data displayed is refined by the value of the element you
drill down on. For example, if you drill down to city on the bar that represents
California at the state level, you will get data on all of the cities in
California.

The field wells you can use to create drill-downs varies by visual type, so refer
to
the topic for a given visual type to learn more about its drill-down support.

Drill-down functionality is added automatically when you associate a date field with
the drill-down field well of a visual, for example using a date in the Group/Color
field
well of a scatter plot. In this case, you can always drill up and down through the
levels of date granularity (year, month, week, day, and hour).

Adding a Drill-Down

Use the following procedure to add drill-down levels to a visual.

On the analysis page, choose the visual you want to add drill-downs
to.

Note

You can't add drill-downs to pivot tables.

Expand the Field wells pane.

Drag a field that you want to use in the drill-down hierarchy to an
appropriate field well, depending on the visual type. Position it above or
below the existing field based on where you want it to be based on the
hierarchy you are creating. Make sure that the label for the dragged field
says Add drill-down layer.

Continue until you have added all of the levels of hierarchy you want. To
remove a field from the hierarchy, choose the field and then choose
Remove.

To drill down or up in order to see data at a different level of the
hierarchy, choose an element on the visual (like a line or bar), and then
choose Drill down to <lower level> or
Drill up to <higher level>. In this example,
from the region level you can drill down to state or up to country to see
data at those levels. If you drill down to state from the
Northeast region, you see only states in that
region.

After you drill down to see data at the state level, you can then drill
down further to see city-level data, or go back up to region. If you drill
down to city from the color block representing NJ, you
see only cities in New Jersey.