• 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

    Creating Parameters

    To create a dashboard parameter in the Web Dashboard, perform the following steps.

    1. Invoke the Dashboard Menu and select Parameters.
    2. In the Parameter List, click the Add New Parameter button. The following settings will be displayed for the created parameter.

      WebDashboard_Parameters_NewParameter

    3. Specify the following parameter's settings.

      • Name - Specifies the parameter name.
      • Description - Specifies the parameter's description.

        The parameter's description is the value displayed in the Parameter Name column of the Dashboard Parameters dialog.

      • Visible - Specifies whether or not the parameter is visible in the Dashboard Parameters dialog.
      • Allow Null - Specifies whether or a not null value can be passed as a parameter value.
      • Allow Multiselect - Specifies whether or not multi-selection is enabled for the current parameter.
      • Select All Values - Specifies whether or not all parameter values should be selected in the initial state. Note that this option is in effect when Allow Multiselect is set to true.
      • Type - Specifies the parameter type.
      • Default Value - Specifies the default parameter’s value.
      • Look-Up Settings - Specifies the parameter's look-up editor settings. To learn more, see the next step.
    4. Depending on the selected Look-up Settings option, you need to specify the following settings.
      • No Look-Up - Allows you to specify the required parameter value manually in the Dashboard Parameters dialog.
      • Static List - Allows you to select a parameter value defined in a static list. To add predefined parameter values, use the + button.
      • Dynamic List - Allows you to select a parameter value defined in a data source. To provide access to data source values, specify the following options.
        1. First, select the required Data Source from the list of available data sources. For the SQL data source, select the required Data Member that specifies the query/data member from the selected Data Source.
        2. Then, specify data members for the dashboard parameter's value and display name using Value Member and Display Member, respectively.
        3. If necessary, specify the data member used to sort parameter values using the Sort By option. The Sort Order specifies the required sort order.
    Back to top Copyright © 2020 Metric d.o.o. www.mymetric.net, metric@zg.t-com.hr