Set up a Drill-through

In the previous tutorials, we have created the Movies Statistics Overview dashboard which gives an overview of the whole movie industry.

While looking at the big picture, we also want to quickly glance at a company that we find interesting:

Let's say we already have a Movie Production Companies Overview dashboard that provides detailed company-level metrics:

With Holistics's Drill-through feature, you can seamlessly use a data point in dashboard A to filter and view dashboard B without leaving the dashboard A's view.

To do that:

  1. In the Company dashboard, create a field filter with the following path: Movies Analysis โ†’ Production Companies โ†’ Company name:

  2. Enable Drill-through, then click Submit to finish.

    The filter will have a small arrow icon that indicates this one has Drill-through enabled:

    Now when viewing any widget that use the same Movies Analysis โ†’ Production Companies โ†’ Company name field, you can drill to this dashboard.

  3. To test the setup, go back to the Movies Statistics Overview dashboard. Right click on the cell that contains Warner Bros. value, you will see a new option available in the menu.

  4. Click on the Movie Production Companies Overview option. The dashboard will appear in a modal, and you can see the Warner Bros. value was used as a filter value: