Using the Data Frames Data Source in a Dashboard

Create dashboards using the Data Frames data source.

  1. In SystemLink Enterprise, navigate to Overview » Dashboards.
  2. Click » New dashboard.
  3. Click Add visualization.
  4. In the Query tab, set the Data source to SystemLink Data Frames.
  5. Select a Query Type to view the appropriate type of data.
    Query Type Description
    Data
    Returns time-series data and tabular data that is suitable for the following visualization types:
    • Time series
    • Bar chart
    • Table
    • Histogram
    • Plotly chart
    • XY chart
    Properties

    Returns data table properties and column properties.
  6. In the Query Configurations section, add filters to the following sub sections to filter the data to a specific data table.
    • Query by result properties
    • Query by data table properties
    • Query by column properties
    Note If the filters match more than 1,000 data tables, the data source only processes the first 1,000 data tables.
  7. Based on your Query Type, update the configuration of the data source.
    Query Type Data Table Properties
    Data
    1. In the Columns drop-down, select the columns you want to visualize.
      Note You can select up to 20 columns.
    2. In the Decimation Settings section, specify the column of values for use as the x-axis when decimating the data in X-column field.
      Note The default value of the X-Column field is the index column of the data table.
    Properties
    1. In the Data Table Properties drop-down, select the data table properties to display.
    2. In the Column Properties drop-down, select the column properties to display.
    3. Set the Take value.
    Note The default Take value is 1,000. This value is also the maximum limit.
  8. Click Save.
Note For more information on improving the query performance, refer to Improving Data Table Metadata Query Performance.