Skip to main content

Customize drill fields

Drilling is a great way to invite users to dig deeper into the data. For example, if you have a measure Order Items Count with a value of 10, drilling lets you see more details on those 10 order items. By default, when you drill, Omni will show the first 10 columns defined in your view. However, you can curate what columns are shown upon drilling in the workbook or the model IDE.

Option 1: Workbook

  1. In a workbook query tab, click and select Modeling > Edit:
  2. Use the Drill fields section to add, remove, and reorder the drill fields:
These changes will only exist for this workbook unless you promote them to the shared model.

Option 2: Model IDE

To customize the available drill fields on a measure, use the drill_fields parameter:
Measure with specific drill fields
count:
  drill_fields:
    [
      users.id,
      users.full_name,
      users.email,
      users.age,
      users.state,
      users.country,
      "users.created_at[date]"
    ]
  aggregate_type: count
You can also specify a default set of drill fields for all measures in a view with the default_drill_fields view parameter:
Default drill fields for order_items view
default_drill_fields:
  [
    id,
    user_id,
    users.full_name,
    inventory_items.product_name,
    sale_price,
    margin,
    "order_items.created_at[date]",
    status
  ]