> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omni.co/llms.txt
> Use this file to discover all available pages before exploring further.
## Submitting Feedback
If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:
POST https://docs.omni.co/feedback
```json
{
"path": "/guides/workbooks/custom-drill-fields",
"feedback": "Description of the issue"
}
```
Only submit feedback when you have something specific and actionable to report.
# Customize drill fields
> Curate the columns displayed to users when drilling.
export const categoryIcons = {
'administration': 'lock',
'api': 'terminal',
'connections': 'database',
'dashboards': 'table-columns',
'embed': 'code',
'errors': 'exclamation',
'modeling': 'wrench',
'patterns': 'plus',
'schedules & alerts': 'envelope',
'visualizations': 'chart-column',
'workbooks': 'book'
};
export const GuideSidebar = ({category, relatedLinks, updatedDate}) => {
const [progress, setProgress] = React.useState(0);
React.useEffect(() => {
const sidebar = document.querySelector('.guide-sidebar');
if (!sidebar) return;
let container = sidebar.parentElement;
while (container && !container.querySelector('.guide-header')) {
container = container.parentElement;
}
if (container && !container.classList.contains('guide-page-layout')) {
container.classList.add('guide-page-layout');
}
}, []);
React.useEffect(() => {
const handleScroll = () => {
const scrollTop = window.scrollY;
const docHeight = document.documentElement.scrollHeight - window.innerHeight;
const scrollPercent = docHeight > 0 ? scrollTop / docHeight * 100 : 0;
setProgress(Math.min(100, Math.max(0, scrollPercent)));
};
window.addEventListener('scroll', handleScroll, {
passive: true
});
handleScroll();
return () => window.removeEventListener('scroll', handleScroll);
}, []);
const icon = category ? categoryIcons[category.toLowerCase()] || 'book' : 'book';
return ;
};
export const GuideTitle = ({title}) => {
return
{title}
;
};
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](/modeling/develop/promotion).
## Option 2: Model IDE
To customize the available drill fields on a measure, use the [`drill_fields` parameter](/modeling/measures/parameters/drill-fields):
```yaml title="Measure with specific drill fields" theme={null}
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](/modeling/views/parameters/default-drill-fields):
```yaml title="Default drill fields for order_items view" theme={null}
default_drill_fields:
[
id,
user_id,
users.full_name,
inventory_items.product_name,
sale_price,
margin,
"order_items.created_at[date]",
status
]
```
2. Use the **Drill fields** section to add, remove, and reorder the drill fields:
