Define a Data Frame Control

The Data Frame Control is used to transform data from one or more rows into either an array of data values or a series of columns. The Data Frame takes the values from the specified Value Column(s) and translates them based on the Frame Column. All other columns are effectively treated as group-by columns. This transformation is usually required for input to a Sparkline visualization.

NOTE: The Data Frame Control block in SysTrack Dashboard version 8.0 (and above) includes the option of two data frame modes: Transpose and Condense. If you are using SysTrack Version 7.2 or lower, follow instructions for Defining a Data Frame Control.

  1. Drag a Query Data block to the workspace and define the Query Data block as necessary.
  2. Add a Data Frame Control to the workspace and connect a Query Data block as input to the Data Frame Control.

    3. NOTE: The Data Frame Control object will not appear when you view the dashboard.

  3. In the Mode field select either Transpose or Condense from the drop-down list.

Transpose Mode

  1. Select Transpose Mode to take the different rows value columns and choose to:
    • Check Create a new column for each frame to convert the different rows' value columns into new columns for each frame (index) value:

      • OR

    • Concatenate them into a single array column:

  2. Select a Frame Column from the drop-down list (the columns are defined in a visualization object, such as the grid in the example above). The Frame Column is the index column around which the data will be transformed.
  3. Specify Value Columns. This is the column whose values will be concatenated or placed into a series of columns. Select a Value Column from the drop-down list. If you selected Create a column for each frame in Transpose mode, click the Apply button, otherwise continue with step 4 below.
  4. To add another Value Column, click the Add Value Column button to select another value column. Repeat this step for each Value Column you wish to add.
  5. When you are done, click the Apply button.

Condense Mode

  1. Select Condense Mode if you wish to concatenate individual column values into a single array column:

  2. Enter a name of your choice in the Condensed column name field.
  3. In the Choose columns list place a check mark in columns you wish to concatenate in the Condensed column (These values are defined in the linked Query data block).
  4. When you are done, click the Apply button.