> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Drill down control

> Learn how the drill down control element works in Sigma workbooks for step-by-step interactive data exploration.

## Requirements

* To create a drill control, your account must have **Can Edit** access to the workbook.
* The activities described on this page are only available in Edit mode. To begin editing, click **Edit** in the top right corner of the page. For more information see [Workbook Lifecycle](/docs/workbook-lifecycle-explore-draft-and-publish).

## Create a drill control

1. In the editor panel, click **+ADD NEW** .
   The **ADD NEW** panel opens.

2. In the **CONTROL** **ELEMENTS** section, select **Drill Down**.

   ![Add New panel with Drill Down highlighted in the Control Elements section.](/_fern-img/121978f7283b7a9b8f46ba7f12ab24a674ecb9a97d024514f0dbafcb5723ee40.webp)

   The new drill down element appears on the page.

3. In the editor panel **SETTINGS** > **Value source** section, use the dropdown list to select a data element containing the columns that you intend to use in the drill path.

   ![Drill Down control settings with the Value source dropdown highlighted and no source selected.](/_fern-img/b8e6c0c9136a6ae2f630aafb23376136ee694c2fcc0fefcd552f7d2b72a74d26.webp)

   If the selected data element supports drill downs, Sigma adds a column under **DRILL CATEGORIES**. You can keep this, change it, or add more.

4. Next to the **DRILL CATEGORIES section,** click **+Add drill category** .

5. Select a column from the list.

   ![The Value source column menu open with Year, Product Type, Store Region, Store State, and Store City among the available columns.](/_fern-img/9fd7597e6931e05ea1cdbaf2526444fd36208797dc8bceb45d82f1312af34c96.webp)

6. (Optional) Repeat the step above to add any additional columns to your drill path. The element displays the path.

   ![Drill Down settings with Year, Store Region, and Store State listed as categories and the same path displayed in the control.](/_fern-img/2906ae9a61cdc5296b58679a3be040bed54a01000a22bf529b4a74e7da20a2e5.webp)

7. Add one or more targets to your control. Targets are the data elements that a control manipulates. In the editor panel, click the **TARGETS** tab.

8. Click **+Add Target** .

9. Select a target data element from the list.

   ![The Targets tab for a new Drill Down control with Add Target open and Sales by Year highlighted.](/_fern-img/01e262aefcffc09ae26a574880b6cd6c4a2a882d18007e49ba49857d0dbb1445.webp)

10. The **Map with columns in target** section appears. Use the dropdown menu to map the drill path column to the corresponding column in the target data element.

11. The **SETTINGS** tab shows all the drill categories. You can change the ID and/or the label of the control.

    ![Drill Down settings showing Year, Store Region, and Store State as categories above the control ID and label fields.](/_fern-img/24525d45df687b37bcf8b55ffa1bc86712f997a849d91a5549b6ad53d761623a.webp)

12. Repeat steps 8-10 to add additional targets.

13. To test it, click a category name in the drill control element’s drill path and drill into that category. The target data element updates accordingly.

## Create a drill control from an existing drill path

1. Right click a value in the data element visualization to open its menu.
2. Select **Drill up** > **Create drill control**.

   ![A bar chart context menu with Drill up expanded and Create drill control highlighted.](/_fern-img/a8b82884df597e41b755cc43ad0ffe643e816247d54aa6f40054053c9e44ef8c.webp)

   Sigma adds the control and you can edit it further, if needed.

## Add categories to an existing drill control

1. Select the existing drill down control.

2. In the editor panel **SETTINGS** section, click **DRILL CATEGORIES** > **+Add drill category**.
   \
    ***Note***: The **+Add drill category** button will only be enabled if a **Value source** is selected above.

3. Select a column from the list.

   ![The Add drill category menu open with columns such as Store Name, Store State, Store City, and Store Region.](/_fern-img/b002ddd8ed4ccd96a9d558bb045e893a4016a41f65587927c745a8707768ce7c.webp)

4. Repeat the step above to add any additional columns to your drill path. Sigma displays each drill category in the drill control's drill path.

   ![Drill Down control displaying Year, Store Region, and Store State as its drill path.](/_fern-img/d3e17f899efe681a9b968cbd527e06e530bca4c2546ce8c07f36385c47c39171.webp)

## Add targets to an existing drill control

1. Select the existing drill down control.

2. In the editor panel, click the **TARGETS** tab.

   ![The Targets tab for an existing Drill Down control with Add Target open and Sales by Year available to select.](/_fern-img/f53274a627c782aeedf21010aa1927c5b8a63baa0c3bb95fa0af58c4ac6c1160.webp)

3. Click **+Add Target** .

4. Select a target element from the list.

   ![The target mapping panel with Year, Store Region, and Store State each mapped to matching columns in Sales by Year.](/_fern-img/841ca256b78fc085b9bb411fa28592c534e0cbc63285a0f629b615cf492abfce.webp)

   A box representing your target element appear.

5. Use the drop down menus to map your drill path drill categories to the corresponding columns in the target element.

   ![The Drill Down target mappings for Year, Store Region, and Store State beside a bar chart grouped by Store Region.](/_fern-img/773a57516184df65fa46696721ff7c3c89f9593d390e84faeea69ca8a42d8359.webp)

6. Repeat steps 3-5 to add additional targets.

7. To test it, click a category name in the control element’s drill path to drill into that category. Your new target element updates accordingly.

   ![Bar chart of total sales by Store Region with Store Region selected in the Drill Down control.](/_fern-img/7200208a3863f9c49a76f1f8d59dc17c596e9bc3954998c02c13b71174ca9859.webp)

## Related resources

* [Visualization drill paths (Drill Anywhere)](/docs/visualization-drill-paths-drill-anywhere)
* [Intro to control elements](/docs/intro-to-control-elements)
* [Drill Downs in Sigma (Community)](https://community.sigmacomputing.com/t/drill-downs-in-sigma/2048?_gl=1*h8fxxp*_ga*ODkzMjkyNDY1LjE3MDAwMDU1NzM.*_ga_PMMQG4DCHC*MTcwMTIwOTMxNS4yNC4xLjE3MDEyMTY1MjIuNTguMC4w)