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:
Double-click the matrix attribute or click Edit icon.
Edit the cells and click . Depending on your access and setup, the following options
might be available when you edit the matrix:
: Deletes a row or a column
: Moves the column to the right
: Moves the column to the left
: Moves the row down
:
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