Show TOC

Adding Virtual Columns with Derived ValuesLocate this document in the navigation structure

Context

Database Analyzer Charts allows you to define virtual colums. After defining a virtual column you can work with it as if it were an original column.

Follow these steps to define a virtual colum:

Procedure

  1. Right-Mouse click on a column name in the column list and choose Add new Column from the context menu.
  2. A dialog box pops up and allows you to define a Name, an Acronym and a Script (formula) for the new column. Note: it is not necessary to use an equal sign (=) to start the formula. You can specify any formula by making use of existing columns. As a typing aid just type CTRL + Space and all available column names appear in a list to be picked out.
  3. Click Finish to close the dialog box. The virtual column will be added to the table.