Adding Tabular Columns

1. Double-click a column header.

2. The Add Column dialog box opens. NetDiver populates some boxes depending on the cBase or model and existing DivePlan or cPlan.

   

3. In the Column Name box, enter a name for the column.

   NOTE: When assigning a column name, be sure that you do not duplicate an existing column name. Use alphanumeric or underscore characters only. Other characters can adversely affect calculations.

4. If you want the column label to be something other than the column name, select Label is different from name.

   A text box appears adjacent to Label is different from name. Enter the label that you want to appear on the dive window column heading. This label can include characters that are not allowed in the column name. If you enter $(<QuickView_name>), the QuickView value appears as the label.

   NOTE: The column label is used in reports and graphs that are generated from the tabular display. However, you must use the column name for other types of references, such as calculation and time-series references.

5. In the Definition box, enter a calculation whose result you want to display in the column. You can enter the calculation syntax directly in the box, or click column names, symbols, and math operators on the window to create the calculation. You can also use a Spectre-language calc.

   If you are entering calculations in the Spectre language, you must enclose the expression in backticks. For example:

   `filter( dimcount ("OrderNbr"), value("DeliveryDate") = today() )`

   In this example, the calculation was created by clicking Total, Revenue, the minus operator, and Cost.

   

   For more information, see Tips for Defining Column Calculations.

   The Other Columns box lists calculations that were created previously, if there are any.

6. In the Model Columns section, you can specify a column type and summary to be used in the new column.

   • Total: Displays the row value
   • Minimum: Displays the minimum value associated with the row value (available only if specified when the cBase or model is built)
   • Maximum: Displays the maximum value associated with the row value (available only if specified when the cBase or model is built)
   • Average: Displays the average value associated with the row value—Total Summary/Count, where Count is the number of records in the row (the number of records that meet the criteria for this dive)
   • %Total: Displays the percent of the summary total that each row value represents—Total Summary/parent (Total Summary)*100
   • Std. Dev.: Displays the Sample Standard Deviation for the row values (available only if specified when the cBase or model is built)
7. Under Info Columns, you can also select info fields that you want to include.
8. In the Calcs section, you can select additional summary columns to include.

9. Below the list of info fields and the list of calcs, you can select Count to display the number of records matching the current row's dimension value (the number of records that meet the criteria for this dive) or %Count to display the percentage of the count.

   NOTE: The value of the count is determined by your Diver developer and is specific to the cBase or model.

10. In the Functions area, you can select mathematical functions to use in the calculation.
11. Click OK to close the Add Column window.

12. In the Edit Columns window, the new column appears at bottom of the list.

    

13. Click OK to close the Edit Columns window.
14. The new column is added to the dive window.