# Set-up Viz extension

To set up the Viz extension, you will need to create or use a datasheet with a recursive data structure. The dataset at least needs two key columns. One for parent keys and one for child/row keys. The root of the tree needs to be a child key with a null value as its parent key. An empty cell in Tableau also works.

A label column can be added to show a name instead of the child key. The label on the same row of the child/row key will be shown.

Here is a small table of example data:

| Parent | Child | Label     |
| ------ | ----- | --------- |
| null   | 1     | CEO       |
| 1      | 2     | Manager 1 |
| 1      | 3     | Manager 2 |

The HierarchyFilter extension can be loaded into the datasheet using the Viz trex or by using the extension exchange. After loading in the extension, the datasheet should look like this.

<figure><img src="/files/VSPbZ7Lpi2pxHbl92tpk" alt=""><figcaption></figcaption></figure>

You can start a recursive tree by dragging dimensions or measures onto the Detail mark in the marks pane. After which, the datasheet might look like this.

<figure><img src="/files/vGTGAAjFnUWEhSv6azZ3" alt=""><figcaption></figcaption></figure>

The order of these items do not matter. We need to click on the Format Extension button in the marks pan to further set up the HierarchyFilter.

<figure><img src="/files/jx6MAESdy4ZRRUtxArN2" alt=""><figcaption></figcaption></figure>

On the first page of the configuration, The "Recursive" block needs to be selected as seen above. After which, we can go to the next page.&#x20;

<figure><img src="/files/uvAbCTOUUXaf92FJdra7" alt=""><figcaption></figcaption></figure>

On the second configuration page, we need to select the correct columns for the parent key, child key and label. The rest of the configuration is optional and can be skipped for now. for more information these options, go to the Configure the HierarchyFilter.

Click on next and after that on submit to save the configuration. Your tree should now be visible in the datasheet.

<figure><img src="/files/8DQsKD2aTL2ocMKg0qTj" alt=""><figcaption></figcaption></figure>

From here, you can use the HierarchyFilter in dashboards by dragging in this datasheet. It is important to click the "use as Filter button" on the extension box.

<figure><img src="/files/UoaVDVoLEe6GBAXYzFB1" alt=""><figcaption></figcaption></figure>

Now that this button is enabled, clicking any item in the tree should filter on the rest of the dashboard items.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.infotopics.com/hierarchyfilter/getting-started/recursive-dataset/set-up-viz-extension.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.