Matrix

A matrix attribute consists of a grid that contains cells. The cells can be empty or can contain text, a number, or an expression.
To change the value of a matrix:
  1. Double-click the matrix attribute or click Edit icon.
  2. Edit the cells and click save. Depending on your access and setup, the following options might be available when you edit the matrix:
    • Red X: Deletes a row or a column
    • Right arrow: Moves the column to the right
    • Left arrow: Moves the column to the left
    • Down arrow: Moves the row down
    • Up arrow: Moves the row up
    • Add Row: Adds a row to the matrix. The row is added below the other rows.
    • Add Column: Adds a column to the matrix. The column is added to the right of the other columns.
    • Data range in rows from: Determines which rows to use when the table or chart is displayed
    • Data range in columns from: Determines which columns to use when the table or chart is displayed
    • Display as: Changes the way the values in the matrix are displayed. Choose from the following display options:
      • Table
      • Table Without Headings
      • Line Chart, Horizontal Bar Chart, Vertical Bar Chart: Graphical representations of the values in the matrix. The charts can be displayed only if the cells contain numerical values: either plain numbers, or results from numerical expressions.
    • Flip matrix axes: If this is selected, the matrix columns are displayed as rows and the rows are displayed as columns in the attribute list.
    Note: Do not mix "." (period) and "," (comma) in a matrix. Enter only numbers that use period as separators. If you include numbers that use comma as separators, before calculation, use the string replace function to remove or replace the commas.
    Note: Line charts are displayed properly if your data range is in one of the following configurations:
    • At least two columns and at least two rows
    • One row and at least two columns when Flip matrix axes is not selected
    • One column and at least two rows when Flip matrix axes is selected

Feedback