Provide Interactivity to the Dashboard

This tutorial describes how to provide the drill-down functionality to a Grid dashboard item and use this item as a filter for other dashboard items.

This topic consists of the following sections:

Enable Drill-Down

The drill-down functionality allows users to change the detail level of data displayed in a dashboard item.

The grid item supports drill-down for rows and requires several dimension columns to be arranged from the least detailed to the most detailed.

Invoke the grid's Bindings menu, click Add Column and select the ProductName data field. Move this column to the second position using drag and drop.

rs-dashboard-grid-two-dimesion-columns

Go to the grid's Interactivity menu and enable the Drill Down option.

rs-dashboard-grid-drill-down-option

You can now click a grid row to display detail data.

rs-dashboard-grid-drill-down-result

Click the Drill Up rs-dashboard-grid-drill-up-button button in the item caption to return to the previous detail level.

Use Master Filtering

Invoke the grid item's Interactivity menu and use the Master Filter Mode option to make the grid act as a filter for other dashboard items. Choose the Multiple mode for this tutorial.

rs-dashboard-grid-master-filter-mode

Click a grid row to make other dashboard items display only data related to the selected record. The following image demonstrates how this affects the chart item.

rs-dashboard-grid-master-filtering

Use the Milti-Select rs-dashboard-grid-master-filtering-multiselect-button button in the grid caption to allow selecting multiple rows.

rs-dashboard-grid-master-filtering-multiple

Click the Clear Master Filter rs-dashboard-grid-clear-master-filters-button button to reset filtering.

You can prevent a specific dashboard item from being filtered by enabling its Ignore Master Filters option.

rs-dashboard-chart-ignore-master-filters

See Also