Skip to main content

Jama Connect Help

Add a lookup matrix

A lookup matrix serves as a source for logic-based calculations in lookup matrix type calculated fields.

To add a logic-based calculated field to an item, you must first add the lookup matrix and give it a name. Adding an optional description defines how the lookup matrix is used in calculated fields.

To configure a lookup matrix, you must select a pick list for the matrix columns, rows, and results.

To add a lookup matrix:

  1. Create pick lists for the calculation inputs (matrix rows and matrix columns) and the calculation results (matrix values):

    1. Select Lookup matrix as the pick list type.

      The Add pick list window shows the drop-down menu options for the Pick list type field.
    2. (Optional) To change the table color from default gray, select a row in the Pick list values table, select Edit values, and select a color.

      The Edit value window shows an example field values with green as the selected color.
  2. Select Admin > Organization > Lookup matrices.

    The Lookup matrices page displays a table with example name, description, and actions.
  3. Select Add lookup matrix.

    The Add lookup matrix button is highlighted on the Lookup matrices page.
  4. Enter a name and optional description for the lookup matrix.

  5. Configure the lookup matrix settings:

    1. Under Matrix Configurations, use the drop-down selectors to configure the matrix columns, rows, and values/result.

    2. Select Generate matrix, then select matrix values for each matrix cell according to the logic-based calculation outcomes you need.

      For example, when the P-total field has a value of High and the Severity field has a value of Low, the calculated field for Risk Score returns the result Tolerable in orange.

      The Generate matrix button is selected on the Description page for adding a lookup matrix; below is an example table of cells to define.
  6. Select Save & done.

  7. Select from an existing item type or add a new item type, then select Add field.

  8. Confirm that the calculation input fields were added to the item: make sure the pick lists match the configuration pick lists used for the calculation lookup matrix source you want.

  9. In the Add field window that opens, select Lookup matrix as the calculation type.

    Select from an existing lookup matrix as the calculation source, then select from available fields as calculation inputs.

    The Add field window displays the fields and options for defining the field, with the Calculation Type drop-down menu expanded.
  10. Select Save.