*
Concepts
*
Tasks
 

Changing Column Properties on an Ad Hoc Basis

You can quickly make changes to the appearance of columns in a table.
Changes made on an ad hoc basis are not saved to the table configuration beyond your APM session unless you save them specifically. To save your changes, see Saving Ad Hoc Changes in the Current Configuration or Saving Ad Hoc Changes as a New Table Configuration.

To Change Column Properties on an Ad Hoc Basis

1.
View the table configuration you want to change.
2.
Right-click the column and click Properties. The Properties dialog appears, open to the General tab.
3.
On the Properties tab, enter the appropriate information.
Setting Name
Description
Sequence number
The number that determines the order in which columns are displayed. The column with the lowest number appears at the left of the table configuration. By default, the sequence number increases by five for each column to make it easier for you to move columns without renumbering all of them.
Column width
The width of the column in pixels. When you select a column type, APM enters the default column width. You can change the width if necessary.
Allow or freeze horizontal scrolling
When the Freeze option is selected, the column appears frozen at the left of the table configuration. Freezing the column enables you to see the information it contains as you scroll across to view other columns. Any column to the left of the frozen column will also be frozen.
Hide this column
When this option is selected, the column is hidden in the table configuration. A hidden column is included in the table configuration but is not displayed. You can filter or sort data by hidden columns.
Include this column in row tooltip
If this option is selected, the column name appears in row tooltips that are displayed in tables that contain the column.
Alignment
The alignment of data within the column. The possible choices are left, centered, and right.
4.
Select the Formatting Options tab. This tab is available for column types that support it, for example, icon, strings that support in-cell editing, date and time, and HTML text. The options available on the tab differ according to the column. Here is an example for a string column that supports in-cell editing:
Setting Name
Description
Selector type
If the column supports in-cell editing, you can select how information is edited. There are four possible values:
•
None - you cannot edit data within the table configuration.
•
Dropdown - you can open a list of items from the table cell to select the correct one.
•
Popup - a dialog appears from which you can select the correct item.
•
Both - you can use either a drop-down list or a popup dialog to select the correct item.
Here is an example for the icon column type:
Setting Name
Description
Icon size
If this column displays an icon, you can choose from these sizes:
•
Small (16x16 pixels) - this is the default size of most icons
•
Medium (32x32 pixels)
•
Large (48x48 pixels)
Flash
When this option is selected, the icon flashes when it appears in the table configuration.
Here is an example for a column that supports HTML text:
Text can be formatted in this column type as either plain text or HTML.
Tip: If the column contains graphics or photographs, you can display them in tables as HTML. Select HTML and click OK. In the table, the content of the column is rendered as HTML. For example:
 
5.
Select the Grouping and Aggregation tab to set options for data groups. Once you have created a data group, you can include a summary of any numeric data available for the items in the group. For example, in a table configuration of assets, you might group the assets by asset type. If you include the Priority Ranking column in the configuration, you could then include the average priority ranking in the group summary. For more information about data groups and aggregations, see Creating Data Groups in Table Configurations.
Setting Name
Description
Group by This Column
Grouping data combines the data from several rows in the table into one row. Selecting this option means data is grouped by the information in this column. If the column is a time and date column, you can choose to group by day, hour, minute, month, or year.
Pivot on this column
When this option is selected, the table is pivoted based on the first and second columns. When you pivot a table, you create a grid in which the first column defines the rows and the second column defines the columns.
Aggregate Type
The type of aggregation used for this column. There are five possible types:
None: No data aggregation is displayed for this column.
Sum: All of the values in the column are added together to produce a total value.
Average: All of the values in the column are added together and divided by the total number of rows to produce an average value.
Maximum: The highest value in the column is selected.
Minimum: The lowest value in the column is selected.
6.
Select the Search Bar tab.
Setting Name
Description
Make this column available for search bar searches
Select this option to add this column to the list of columns that can be searched from the quick search bar, or clear the option to remove the column from the list.
By default, when the quick search bar is turned on, all text string columns in the configuration are available to search. However, you can turn off the search feature for individual columns. For example, if a column is hidden, you might not want to include it in quick searches.
Search this column by default
Select this option if you want the column to be searched by default when users run quick searches. For example, in a configuration that has 10 text string columns, you might want all of them to be available for searches, but normally you only want to search on one or two. If a column is not set up to be searched by default, users must select the column manually when using the quick search bar.
7.
Click OK. The column’s appearance changes, but the changes will not be saved longer than your current session.