Add a status indicator column to a table

About this task

Applies to: TBM Studio 12.0 and later

In tables in reports, you can add status indicators that use color icons to provide information about values in a column. In the following image, the status indicators in the CPU Status column provide information about the values in the Avg CPU Util column. The indicators can be keyed to value ranges. For example, a green arrow points up for a server with CPU utilization above 65%, a yellow arrow points to the right for CPU utilization above 50%, and a red arrow points down for CPU utilization below 50%.

Icons generated by the Icon function

The status icons are generated by the following function:

=Icon(["icon_type"],conditional_expression,conditional_expression+)

Several types of icons are available. The table below lists the types, the expressions, and the results for each expression. Different icon types have different numbers of expressions. Expressions are evaluated in the order they are listed in the function. If an expression is true, the result for that expression is displayed in the table and the remaining expressions are ignored. The icon_type argument is optional. If you omit the argument, the function defaults to the redcircles icon type. If you include the icon type, enclose it in quotes. Values that do not fall within the expressions entered are assigned the last icon in the set.

Table 1.
Icon Type	Expressions and Results
redcircles	Expression 1: red circle Expression 2: pink circle
3colorcircles	Expression 1: green circle Expression 2: yellow circle Expression 3: red circle
3arrows	Expression 1: up arrow Expression 2: right arrow Expression 3: down arrow
3arrowsinv	Expression 1: up arrow Expression 2: right arrow Expression 3: down arrow
4arrows	Expression 1: up arrow Expression 2: up-right arrow Expression 3: down-right arrow Expression 4: down arrow
4arrowsinv	Expression 1: up arrow Expression 2: up-right arrow Expression 3: down-right arrow Expression 4: down arrow
5arrows	Expression 1: up arrow Expression 2: up-right arrow Expression 3: right arrow Expression 4: down-right arrow Expression 5: down arrow
5arrowsinv	Expression 1: up arrow Expression 2: up-right arrow Expression 3: right arrow Expression 4: down-right arrow Expression 5: down arrow

Procedure

Navigate to the report page containing the table and switch into Edit mode.
Select the table.
On the Data tab, click Insert.
If you wish, change the name on the column by right-clicking in the column header, selecting Rename, and entering a new name.
Select the column you just inserted.
Click the Formulas tab, open the Advanced functions, and click the Icon option.
Edit the formula, selecting the appropriate icon type and entering the matching number of expressions.

A sample formula is shown below.

Icon("3arrows",Avg CPU Util<40,Avg CPU Util<50,Avg CPU Util>70 AND Disk Image GB=500)
Save the formula by clicking the save icon to the left of the formula field. If you entered the formula correctly, the status icons will be displayed in the column. If you made an error in the formula, the application displays an error message in the column that may help you troubleshoot the formula.