Adding interactive dashboard widgets

You can add interactive widgets to a dashboard, so your viewers can interact with, and customize their results. Only editors can add interactive widgets, but any viewer permitted to view a dashboard can use them.

For help using interactive widgets, see Interacting with dashboards.

This article contains the following sections:

• Filtering results
• Selecting new metrics and attributes
• Adding reference interaction options

Filtering results

Viewers can use filter interactive widgets to restrict results to specific attribute values, date and number ranges, or the highest and lowest results.

The following are the available types of filters:

• Data filter
• Time filter
• Metric filter
• Top/bottom

Data filter

A data filter enables viewers to filter results by an attribute's values. Viewers can divide data by an additional attribute without the results appearing on each query.

To add a data filter

1. In the Dashboard menu, click Add > Add data filter.
2. On the Choose data filter dataset panel, choose the dataset you want to filter. You'll only see this panel if you've added multiple queries that use different datasets to your dashboard.
3. In the Choose data filter columns panel, select the attribute you want to use.

   

   Before you choose a date attribute, think about how you want your viewers to be able to filter the dashboard. For example, a common filter might be the date the ticket was created, so you'd choose the Ticket created - Date attribute. The attribute you select must be part of the dataset that was used to create the query you’ve added to the dashboard.

   You can either browse the available attributes in the list, or refer to Understanding Explore datasets for a full list of available values for the dataset you are using.

4. Enter a Display name and Width to set a custom name and width for the attribute.
5. Select a position from the Display drop-down list to set how options appear.
6. Select from the following additional options:
   • Multiselection enables viewers to select more than one value
   • Cascade prompts applies the data filter to other filters. For example, if you are using two separate data filters for Ticket Tags and Ticket ID, you can check Cascade prompts, so when a viewer selects a tag, only the ticket IDs for that tag will be available.
   • Check the Promote URL as parameter box to embed your filter in the dashboard URL. You can type a new value directly in the URL to update your filter. For more information about this option, see Customizing dashboards with URL parameters.
   • If your dashboard uses multiple datasets, you can enter a common attribute in the Link with box to apply the filter across all of your dashboard's datasets.
   • Check the Do not share across tab box to apply the filter to only the selected tab.
7. In the Sort drop-down list, select the order of values. Values can be sorted alphabetically from A-Z or Z-A.
8. When you are finished, click Apply.

Your data filter interaction will resemble the image below.

Time filter

A time filter enables users to edit the displayed time period.

To add a time filter

1. In the Dashboard menu, click Add > Add time filter.
2. In the Time filter widget panel, select a date attribute to use in the filter.
3. Edit how the time filter is rendered (calender by default) and the level of detail. These options are available underneath your metrics.

   

4. When you are finished, click Apply.

Your time filter widget will resemble the image below.

Metric filter

The metric filter interactive widget is similar to the metric filter manipulation in Query Builder (see Selecting the metric result range). Viewers can use the metric filter to set a floor or ceiling to results.

To add a metric filter

1. In the Dashboard menu, click Add > Add metric filter.
2. On the Choose metric filter dataset panel, choose the dataset you want to filter. You'll only see this panel if you've added multiple queries that use different datasets to your dashboard.
3. In the Choose metric filter dataset panel, choose a dataset.
4. Select the metric you want to use as a filter.
5. You can then edit the display name, width, and if blank values are filtered.
6. When you are finished, click Apply.

Your metric filter will resemble the image below.

Top/bottom filter

Similar to the top/bottom filter manipulation option in Query Builder, with the top/bottom interactive widget your viewers can limit results to the highest or lowest values. For more information on the top/bottom filter in Query Builder, see Creating a top/bottom filter.

To add a top/bottom filter

1. In the Dashboard menu, click Add > Add top/bottom.
2. In the Top/Bottom panel, enter your top and bottom values and set their visibility.

   

3. Select a strategy. The strategy will determine what attribute is used to calculate results.
4. Add metrics in the Metrics textbox.
5. Select a Display type. You can display measures in either a drop-down or button list.
6. When you are finished, click Apply.

Your top/bottom filter will resemble the image below.

Selecting new metrics and attributes

When you select these interactive widgets, your viewers can edit the initial metrics or attributes to view other possible outcomes.

The following interactive widgets that enable your viewers to edit existing metrics or attributes:

• Change metric
• Change attribute
• Global variable

Selecting a different metric

The change metric widget enables viewers to change the initial metrics, so they can view different outcomes of the same report.

To add a change metric interactive widget

1. In the Dashboard menu, click Add > Add change metric.
2. In Choose change measure dataset panel, select a dataset used on the dashboard.
3. Select the metric that you want to give users the option to change.
4. After you select a metric, you can edit the option display name, width, and display format. You can also permit users to change measure aggregators and restrict the list of available measures.

   

5. When you are finished, click Apply.

Your change metric widget will resemble the image below.

Selecting a different attribute

Similar to a change metric, the change attribute interactive widget enables viewers to select a new attribute.

To add a change attribute interactive widget

1. In the Dashboard menu, click Add > Add change attribute.
2. In the Choose change attribute dataset panel, select the dataset containing the attribute you want to become a change attribute.
3. Select the attribute to become a change attribute.
4. After you select an attribute, you can edit the display name, width, and display format. You can also restrict the list of available attributes.

   

5. When you are finished, click Apply.

   Your change attribute widget will resemble the image below.

   

Editing what if variable values

If you have a what if variable added, you can enable users to change its value. You must use a what if variable in a query to add this interactive widget (see Performing analysis with what if variables).

To add a what if variable interactive widget

1. In the Dashboard menu, click Add > Add what if variable.
2. In the Choose what if variable dataset panel, select the dataset containing the what if variable you want to use.
3. Select the what if variable you want to add.
4. Edit the display name and width of the option box.
5. When you are finished, click Apply.

Your global variable widget will resemble the image below.

Adding reference interactivity

While other interactive widgets edit or filter data, the widgets below enable viewers to change references, such as the date, or switch between saved filtered dashboard states.

The following are the available interactive reference widgets:

• Bookmark

Using bookmarks to save filtered dashboard states

When you add a bookmark interactive widget, it freezes the current state of filters. Viewers can switch to different bookmarks to see different filter states.

To add a new bookmark widget

1. In the Dashboard menu, click Add Add bookmark.
2. On the Bookmark page, click Create bookmark from current state.
3. Enter a display name.
4. You can continue changing the dashboard filter states and adding as many bookmarks as you want.
5. You can delete, rearrange, or pin a bookmark (). Pinning a bookmark makes it the default selected item in the list of bookmarks.
6. If you do not want users to reset a bookmarked state click Hide reset button.

   

7. When you are finished, click Close.

   Your bookmark widget will resemble the image below.