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, it is natural for dashboard viewers to want to explore more on things that they find interesting. Let's set up a drill-through so that they can learn about, say Warner Bros, who is the top perfomer in the industry while viewing our report.

Assuming that 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.

Let's go over the steps 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: