Configure the sidebar

IMPORTANT

Read more about Data Workbench’s End-of-life announcement.

The sidebar provides access to regularly-used functions and preserves visualizations as you move between Workspaces.

Administrators can customize a sidebar to make it appropriate for different user groups, then deploy the sidebar with a profile.

The sidebar is ideal to help you keep track of filters and local overrides. If you prefer not to use the sidebar, you can hide it.

Add visualizations to the sidebar

  1. Launch Data Workbench.

  2. In the sidebar, click Add > < item>. For example, Selections Panel, Filters Panel, or Table.

    The following sidebar panels are available in the standard installation of Data Workbench. More items might be available in your specific profile:

    • Selections Panel: Lets you understand what selections are active in the current workspace. The Selections Panel updates whenever you make a new selection. You can clear selections by clicking x. See Making Selections in Visualizations for information about how to select data.
    • Filters Panel: Makes it easy to load and apply saved filters. You can load multiple filters, and enable or disable each one independently by clicking the check box next to it. See Filter Editors.
    • Local Override Panel: This panel displays which metrics, dimensions, and filters that are present in the profile have been modified in your personal copy of the profile. This helps alert you to possible differences between the way data appears in your client and that of other users. When you save changes in a metric, dimension, or filter to the server, the override is removed from the Local Overrides panel. If you click an override and then click Revert to Server, the local override is removed and the item reverts to the shared version.
    • Metric Legend: Adds a metric legend. Metric legends enable you to see baseline metrics related to your profile and statistics related to the dataset (or to the current selection, if one has been made). See Metric Legends.
    • Color Legend: Adds a color legend. You can color-code visualizations by metrics, such as Conversion and Retention, and use them in almost every Workspace. Linking business metrics to color makes it easy to spot anomalies, exceptions, and trends. See Color Legends.
    • Text Annotation: Adds a notes panel. Text annotations are windows into which you can enter arbitrary text to add descriptive information or comments to a Workspace. See Working with Text Annotations.
    • Table: Adds a table. A table can display one or more metrics across one or more dimensions of data. See Tables.
    • Open: Opens a saved file.

Open a Sidebar Panel

You can open a sidebar visualization file from a saved location or from the clipboard.

  1. In the sidebar, click Add > Open.

  2. Click File to locate the .vw file of the panel you want to add, or click Last Closed Window, which pulls the visualization from the clipboard.

    Additionally, you can click From Clipboard to paste a visualization that has been copied to the clipboard. See Copying a Sidebar Panel.

Copying a Sidebar Panel

  1. Right-click the panel’s top border, then click Copy > Window.
  2. To paste the panel, click Add > Open > From Clipboard.

Saving a Sidebar Panel

On an sidebar panel, right click in the title bar and click Save.

Similarly, you can open a saved sidebar visualization. Data Workbench saves the visualization as a .vw file at the location you specify.

Revert to the Default Sidebar

In the sidebar, click Options > Revert.

When you close Data Workbench, the system saves the current sidebar configuration in the sidebar.vw file in the user profile. When you open Data Workbench, the system loads the sidebar.vw file from the user profile, rather than a parent profile.

You can revert to a default or previously saved sidebar, which deletes the sidebar from the user profile and reloads the sidebar from the parent profile. Administrators can replace the default (parent) sidebar with a local sidebar by uploading it from the Profile Manager.

Customize the More Status Panel File

System administrators can build formulas in the More Status Panel.vw. This places contextual words around metric and dimension values, and displays the results in the More Status panel in the sidebar.

To display the More Status panel in the sidebar, click the arrows shown in the following example.

The following procedure shows a simple example of how to create a customized status that tells you how many days are in a dataset:

  1. In the Profile Manager, click **Sidebar**.

  2. In the Base_5_3* column, make a local copy of the More Status Panel.vw file.

    To do so, right-click the file check mark and click Make Local.

  3. Open the More Status Panel.vw file in the .vw Editor or in Notepad.

  4. Complete the Context and Items fields in the Editor. See Query Language Syntax for guidelines about syntax.

  5. Save the file.

    The values in the preceding example result in a status formula displayed as follows:

On this page