Drilling to Chart Details
  • 17 Feb 2023
  • 1 Minute to read
  • Dark
    Light

Drilling to Chart Details

  • Dark
    Light

👤 This functionality is available for users with the Viewer Workspace Role and above. Reach out to a Team Admin in case this feature is not available to you.

In Preset, you access the chart relevant data and get additional information about a specific metric or a set of metrics by using the Drill to Detail feature on a dashboard view.

There are three ways to drill down to details of a chart:

  1. Drill to detail from drop-down to access all chart relevant data
  2. Drill to detail on a chart to access all chart relevant data
  3. Drill to detail by on a chart to access filtered version of chart relevant data

All charts in Preset support the drill to detail functionality as long as the chart groups data by a dimension value.

Drill to Detail from Drop Down

When you want to display all the data that makes up a chart, you can Drill to Detail from a chart’s drop down menu.

  1. Right click on the vertical ellipsis (⋮) menu of a chart in the dashboard.
  2. Click Drill to detail to view the full table.

d2d_dropdown.gif

Drill to Detail on a Chart

You can also directly interact with the chart to display all the relevant data.

  1. Right click on any part of a chart.
  2. Click Drill to detail to view the full table.

d2d_chart.gif

Drill to Detail By on a Chart

When you want to explore the underlying data of a specific value or a set of values on the chart - i.e., all columns in the dataset for rows filtered to the selected values, you can use the Drill to Detail By functionality.

Drill to Detail By is an interactive way to go from a high-level dimension such as countries, to a lower one such as the United States.

  1. Right click the dimension values on the chart.
  2. Click Drill to detail by, then either select a single dimension, or Drill to detail by all to view the filtered table.

d2d_multi.gif

Tips

  • As you filter the dashboard, Drill to Detail will reflect the applied filters while displaying the underlying data in a tabular format.
  • You can scroll down to 50 rows per page on a Drill to Detail table.
  • When applicable, the Drill to Detail table shows the formatted data by default. You can change the column formatting to the original value by clicking the gear icon.

d2d_formatting.png


Was this article helpful?