Define a Calculate Column for a Matrix Widget
Use the Columns page (in the Matrix Widget Properties window) to define how a calculated column looks and behaves on a Matrix Widget.
A calculated column displays a calculated value that is determined by executing a calculation against other columns in the Matrix (example: Add up open and closed Incidents for a grand total).
The following figure shows an example of how a Matrix Widget uses a calculated column on a Dashboard.
Good to know:
- Calculated columns are calculated after all numeric columns have been retrieved.
- Calculated columns cannot query themselves.
To define a calculated column for a Matrix Widget:
- Create a Widget.
- In the Type drop-down, select Matrix.
- Click the Columns page.
- Click Add>Calculated column.
- Define how the value in the column will be calculated:
- Click the Calculated Value page.
- Click the Selector button , and then select the Tokens (System Functions, Expressions, Stored Values, Metrics, and/or Counters) and math operators to build the calculation.
- Define the format for the column:
- Click the Format page.
- Define formatting options:
- Format: Select a format for the number (example: Number, Percent, Currency/locale symbol).
- Decimal places: Specify the number of decimal places to show for each value.
- Text Position: Select how to align the value in the column (example: Centered, left-justified, or right-justified).
- Color Text: Select this check box to define an Expression that controls the color of the text (example: If the value is negative, show it as red. You cannot use stored Expressions here because regular stored Expressions do not have access to column values).