Create Drill Downs

Drills downs are used by data consumers to explore further a metric. They will be available when the user clicks on the chart and will show the underlying records that have been used to compute the metric.

Drill downs can be defined at the table level or at the metric level. Metric will inherit for the table configuration and can override the table configuration if needed.

Configuring Drill Downs at the table level

Drill at the table level

At the table level drill downs can be:

• Disabled by default: This means that end users won't be able to click on the chart to get access to the records.

• Inherit from the dataset configuration (default): On the dataset that is used to build the table you can define columns that will be used on all metrics

• Use a combination of dimension and metric: You can generate your own query with your own dimension and metrics to make the drills more readable

By default all metrics created under this table will inherit the table configuration

Configuring Drill Downs at the metric level

Configuring drills at the metric level

At the metric level drill downs can be:

• Disabled: If for some reason you want to avoid your users to view records on a specific metric, this can be useful for calculated metrics as record level is not easily understandable.

• Inherit from table (default): This will give you the drills that are configured at the table level

• Select from existing measure: You can generate any query you wish at the metric level