Knowledge Base

Why Drilldowns?

Drilldowns are helpful in showing maximum information by representing data in consumable blocks. It’s a way to send information between two different charts—from a selected field on one chart to another chart showing related information.

In Arcadia, you can apply drilldowns by enabling click behavior on one visual (the driving visual) that will drill down to another visual (the target visuals). This way, you can define where a click on a particular field on a dashboard will lead the user to. The destination can also be an external web page.

In this exercise, you will learn how to:

• Set up driving visuals
• Set up target visuals
• Link a web page to a visual
• Enable click behavior on a driving visual
• Test click behavior
• Apply drilldowns to apps/visuals

Prerequisites

You must have a dataset first. Visit the following links to learn how you can

• Import data from flat files
• Create datasets from imported data
• Create data connections

Enable Click Behavior

The following steps demonstrate how you can enable click behavior on a driving visual and link it to target visuals.

We’re working with the dataset World Life Expectancy from our sample datasets and using the following charts as the driving and target visuals.

Packed Bubbles Chart	World Population Distribution in 2010	Driving Visual
Lines Chart	Population Trend for <<country>>	Target Visual
Lines Chart	GDP Per Capita Trend <<country>>	Target Visual
External Page	Wikipedia Pages of <<country>>	Target Visual

A click on a particular country bubble drills down to the target visuals.

1. Create a driving visual, a Packed Bubbles Chart, showing the world population distribution in the year 2010. Name it World Population Distribution in 2010. Use Country as Dimension, Population as Measure, and the Year 2010 as Filter.
       
2. Create a target visual, a Lines Chart, showing the population trends in various countries over the years. Name it Population Trend for <<country>>.
   Note: We write a parameter within << >> to make it dynamic. Learn more about dynamic parameters.
   Use Year as X-Axis, Population as Y-Axis and Country as Filter. 
       
3. Create another target visual, a Lines Chart, showing the GDP Per Capita trends in various countries over the years. Name it GDP Per Capita Trend for <<country>>
   Use Year as X-Axis, GDP Per Capita as Y-Axis and Country as Filter.
4. Add a Dynamic Link to the visuals, linking the countries in the driving visual to their respective Wikipedia pages.
5. Create an app linking the above visuals and the link. Name it World Population & GDP Trends.
6. Click Apps.
7. Find and launch the app you created. 
       
8. In the World Population Distribution in 2010 visual, click a country name.
   The Country Filter modal appears. 
       
9. In the Country Filter modal, click Enable filter on click.
10. Click on a country bubble.
    The Country Filter modal appears.
        
11. Click Test click behavior.
    Note that the target visuals Population Trend for <<country>> and GDP Per Capita Trend for <<country>> change accordingly. Also, the Wikipedia page below the graphs also changes to that country’s page. 
        
12. Above the left navigation bar, click Save.