Controls

The Controls menu is located on the right side of the navigation bar, and provides access to the folowing features:

• Input Filter
• Dropdown Filter
• Markdown Widget
• Filter Sets
• Linker
• Clear All Filters

Input Filter

Input Filters apply your specified filter to all tables and dynamic plots in your dashboard.

Once you choose a Filter Column from the drop-down list in the Input Filter panel, you will be prompted to enter a value. The filter statement options available in Quick Filters are based on the data types in each column being filtered. (Please refer to the Quick Filter Statement Options in the Appendix for a complete list.) The Sym column has been chosen in the following examples. Once a value is entered, the filter will be immediately applied to your dashboard.

Note that Input Filters will only work on dynamic plots with a selectable dataset, which must be configured using the appropriate plotting methods.

Dynamic plots will not draw until a filter is applied. An Input Filter may be added from the Controls menu, or the button in the plot's panel:

Closing the Input Filter panel removes all the associated filters from the dashboard.

Dropdown Filter

The Dropdown Filter control takes a source column as an input and filter column as an output. It uses the source column to create a dropdown list of filter options. Selecting a value from this list causes all columns in the dashboard that match the filter column name to be filtered by the selected value.

The dropdown list expects unique values for the column source. It is recommended that you create a new table with just the column of interest, and apply a .selectDistinct to get a list of unique values. You can also exclude values by further filtering the Select Distinct table. You can sort the options list by sorting the source column.

Once a Dropdown Filter widget has been added to the dashboard from the Controls menu, you will be prompted to choose a source column. Click the Source Column button and move your cursor to the desired column:

Click Done, then choose an appropriate Filter Column:

The Dropdown Filter will now automatically populate a dropdown list of the available values in the source column. Choose any value to filter all the tables in your dashboard that include the selected Filter Column. Sorting and filtering the source table will update the values in the Dropdown Filter.

For example, the Dropdown Filter below first links to the USym column in a small table of values. The subsequent dropdown list is used to filter the USym column in the other open table to the selected value:

To edit your configuration, click the gear icon at the top right of the Dropdown Filter widget:

Deleting a source column or closing the source table unlinks the Dropdown Filters.

Markdown Widget

The Markdown Widget is a tool for including text (or images) in the Deephaven Web interface. These notes can include references to the queries running in a Dashboard; code snippets/explanations; instructions/comments; messages to customers, clients or coworkers; contact info, etc.

Once a Markdown Widget has been added to the interface from the Controls menu, its content can be edited by double-clicking in the panel.

Content contained in the widget can be styled using the Markdown syntax. Examples of this syntax follows:

Syntax
# Heading 1 Text
## Heading 2 Text
### Heading 3 Text
This is **bold text**
This is *italic text*
> This is a block quote
This is `inline code`
<img src="url" width="e.g., 250">

Additional styling options are available in Markdown, including code blocks, tables, links, lists, horizontal lines, etc.

Managing Markdown Widgets

Markdown Widgets are saved with the Dashboard or Code Studio in which they were originally created. If the Markdown Widget is open when the dashboard is closed, the Widget will remain paired when it is reopened.

If a Markdown Widget is closed during your session, it can be retrieved by selecting Markdown Widget from the Controls menu, and then clicking its name from the Recently Closed list:

Hovering your cursor over the name of a widget will reveal the trash can icon, used to to permanently delete the widget.

Filter Sets

Filter Sets capture the current state of all filters applied across the current dashboard (including plots, tables, etc.) into one "set" that can then be reapplied at a later time.

Capture the current state as a new filter set:

Now, name the set:

After you have saved your first filter set, you can access a drop-down list of all available sets:

The Filter Sets panel will now show the Edit option. You can also delete existing sets from this panel:

Tools

Linker

The Linker feature in Deephaven enables a user to interactively filter the content in one table based on the content selected in another table. The objects must first be "linked" with each other, with one table as the source and one or more as the target. When a cell in the source table is double-clicked, the respective columns in the target table are filtered to that value.

When you select the Linker tool from the Controls menu, the following instructions will appear in Deephaven:

After you click a column source, an arrow will appear as you drag your cursor to your desired target. In the example below, the Sym column in t2 (the source table) is being linked to the Sym column in t1 (the target table).

Click Done to save your changes.

Now that the tables are linked, double-clicking on a row in the Sym column in t2 will automatically filter the contents of t1. As shown below, double-clicking on GOOG in the source table filters the target table to show only rows with the GOOG symbol.

You can also link multiple tables at once, as shown below:

After you've linked tables, your selections are saved and will reopen to allow you to edit or clear the links when you access the Linker.

The Linker tool is also compatible with dynamic plots, which must be configured using the appropriate plotting methods.

Click Clear All to remove your links. Use Remove All Filters or Remove Column Filter in the table context menu to restore the tables to their original state.

Actions

Clear All Filters

The Clear All Filters button removes all filters of any type in the active dashboard at once.