Using Data Tables as Dashboard Variables

Create variables that use data tables to dynamically view dashboard data.

  1. In the SystemLink web application, navigate to Overview » Dashboards.
  2. Click and select the dashboard that contains the variable you want to edit.
  3. Click Dashboard settings.
  4. In the Variables tab, click New variable and enter a variable name.
  5. Expand the Type drop-down and select Query.
  6. In the Query options section, update the relevant properties.
    1. Set the Data Source as SystemLink Data Frames.
    2. Select a Query Type.
      Query Type Description
      List data tables Returns a list of data table names that match the filters.
      List data table columns Returns a list of columns from each data table that match the filters.
    3. Add filters to the following sections to filter the data to a specific data table.
      • Query by result properties
      • Query by data table properties
      • Query by column properties
  7. Click Apply.
  8. Return to the dashboard.
    You can now reference the variable in panels that use the SystemLink Data Frames Data source by typing $ followed by the variable name.