Skip to main content

Interactivity

  • 2 minutes to read

To enable interaction between the Grid and other dashboard items, you can use the interactivity features, as Master Filtering and Drill-Down.

Master Filtering

You can use the Grid dashboard item as a filter for other dashboard items. To learn more about filtering concepts common to all dashboard items, see the Master Filtering topic.

The Grid dashboard item supports filtering by rows.

When Master Filtering is enabled, an end-user can click a grid row (or multiple rows) to make other dashboard items only display data related to the selected record(s).

WebViewer_MasterFiltering

Columns placed after the Measure column do not affect master filtering.

To enable Master Filtering, go to the Grid’s Interactivity menu and select the required Master Filtering mode.

wdd-dashboard-items-interactivity-section

To reset filtering, use the Clear Master Filter button (the wdd-master-filtering-icon icon) in the Grid’s caption.

Note

You can use Master Filter or build criteria in the Filter Editor to filter total values. The Grid column’s drop-down filter menu does not affect grid totals as they are calculated on a server.

Drill-Down

The built-in drill-down capability allows end-users to change the detail level of data displayed in dashboard items on the fly. The Grid dashboard item supports drill-down for rows. To learn more about drill-down concepts common to all dashboard items, see the Drill-Down topic.

When drill-down is enabled, an end-user can click a grid row to view the details.

wdd-grid-interactivity-drill-down

Drill-down requires that the Columns section contains several dimensions at the top, from the least detailed to the most detailed dimension.

wdd-grid-interactivity-several-dimensions

Note

In OLAP mode, you can perform drill-down for either a hierarchy data item or several dimension attributes.

To enable Drill-Down, go to the Grid’s Interactivity menu and turn the Drill-Down option on.

wdd-dashboard-items-interactivity-section

To return to the previous detail level, click the Drill Up button (the wdd-drill-up-icon icon) in the Grid’s caption.