• Metric Reports for Web
  • Dashboard for Web

    Show / Hide Table of Contents
    • Web Dashboard - Designer Mode
      • Creating a Dashboard
      • Providing Data
        • Create a New Data Source
        • Connect to an Existing Data Source
        • Dashboard Data Source Wizard
          • Specify Data Source Settings (Database)
          • Specify Data Source Settings (JSON)
          • Specify Data Source Settings (OLAP)
        • Query Builder
        • Preview Data
        • Manage Data Sources
        • Working with SQL Data Sources
          • Manage SQL Queries
          • Filter Queries
          • Pass Query Parameters
          • Stored Procedures
        • Filter Data Sources
        • Calculated Fields
        • Data Inspector
      • Adding Dashboard Items
      • Binding Dashboard Items to Data
        • Binding Dashboard Items to Data in the Web Dashboard
        • Hidden Data Items
        • Binding Dashboard Items to Data in OLAP Mode
      • Designing Dashboard Items
        • Chart
          • Providing Data
          • Series
          • Panes
          • Interactivity
          • Legend
          • Axes
          • Orientation
        • Scatter Chart
          • Providing Data
          • Interactivity
          • Legend
          • Axes
          • Orientation
          • Labels
        • Grid
          • Providing Data
          • Columns
          • Interactivity
          • Conditional Formatting
          • Totals
          • Layout
        • Pies
          • Providing Data
          • Interactivity
          • Layout
          • Labels
          • Style
        • Cards
          • Providing Data
          • Layout
          • Delta
          • Sparkline
          • Formatting
          • Interactivity
          • Cards Arrangement
          • Conditional Formatting
        • Gauges
          • Providing Data
          • Delta
          • Gauge Scale
          • Interactivity
          • Layout
          • Style
        • Pivot
          • Providing Data
          • Interactivity
          • Conditional Formatting
          • Layout
          • Expanded State
        • Choropleth Map
          • Providing Maps
          • Providing Data
          • Delta
          • Map Navigation
          • Interactivity
          • Labels
          • Legend
        • Geo Point Maps
          • Map Types Overview
          • Providing Maps
          • Geo Point Map
            • Providing Data
          • Bubble Map
            • Providing Data
            • Legends
          • Pie Map
            • Providing Data
            • Pie Options
            • Coloring
            • Legends
          • Clustering
          • Map Navigation
          • Interactivity
          • Labels
        • Range Filter
          • Providing Data
          • Series
          • Interactivity
          • Predefined Periods
        • Date Filter
        • Images
          • Image Overview
          • Providing Images
          • Interactivity
          • Image Settings
        • Text Box
        • Treemap
          • Providing Data
          • Interactivity
          • Layout
          • Grouping
          • Coloring
          • Labels
        • Filter Elements
          • Filter Elements Overview
          • Providing Data
          • Interactivity
        • Dashboard Item Group
        • Tab Container
      • Data Shaping
        • Summarization
        • Grouping
        • Sorting
        • Filtering
        • Top N
        • Formatting Data
      • Interactivity
        • Master Filtering
        • Drill-Down
        • Neutral Filter Mode
      • Appearance Customization
        • Conditional Formatting
        • Coloring
        • Themes
      • Data Analysis
        • Aggregations
        • Calculations
        • Dashboard Parameters
          • Creating Parameters
          • Passing Parameter Values
          • Requesting Parameter Values
        • Expression Constants, Operators, and Functions
      • Converting Dashboard Items
      • Dashboard Layout
        • Dashboard Title
        • Dashboard Item Caption
        • Dashboard Items Layout
      • Undo and Redo Operations
      • Saving a Dashboard
      • Opening a Dashboard
      • Exporting
      • UI Elements
        • Toolbox
        • Dashboard Surface
        • Dashboard Menu
        • Dashboard Item Menu
        • Data Item Menu
    • Web Dashboard - Viewer Mode
      • Data Presentation
        • Data Presentation Basics
        • Master Filtering
        • Drill-Down
        • Dashboard Layout
      • Mobile Layout
      • Dashboard Parameters
        • Requesting Parameter Values
      • Exporting
      • Dashboard Items
        • Chart
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Scatter Chart
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Grid
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Pies
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Cards
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Gauges
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Pivot
          • Exporting
        • Choropleth Map
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Geo Point Maps
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Range Filter
          • Exporting
        • Image
          • Exporting
        • Text Box
          • Exporting
        • Treemap
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Filter Elements
        • Tab Container

    Interactivity

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

    • Master Filtering
    • 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, you can click a grid row (or multiple rows) to make other dashboard items only display data related to the selected record(s).

    WebViewer_MasterFiltering

    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.

    Drill-Down

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

    The Grid dashboard item supports drill-down for rows.When drill-down is enabled, you 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.

    Back to top Copyright © 2020 Metric d.o.o. www.mymetric.net, metric@zg.t-com.hr