Page Comparison

Home > Analytics > Adding Custom Columns & Formatting Columns

...

For details and examples, see Sample Custom Expressions.

Adding a Custom Column

1. To create a custom column, in the Report Designer panel, click +. The Column Properties panel takes its place; you can format the new column there.

...

1. Image Added

2. Enter a Heading for the column.

3. Select a Type.

   • For Type Numeric or DateTime, select a Format.

4. To define the value using a custom expression, next to Expression, click the Edit button.

...

1. Image Added

   Note: The Edit Formula form is case-sensitive. For example, VoyageStatus=="commenced" is different from VoyageStatus=="Commenced"
   You can create a custom expression using Functions and Operators.
   For details on Functions and Operators, see

...

1. IMOS - Custom Expression Functions.

2. To save the report, click << Report at the top of the Column Properties panel and then click Save.

Referencing other columns in Custom Expressions

...

Formatting a Column

1. To format a column, open the Column Properties panel:

   • For a custom column, follow the steps above.

   • For an existing column, click it in the Report Designer panel.

2. Edit any of the following fields:

   • Bold, Italics: Enter either "Y" (Yes) or "N" (No).

   • Font, Font Color, Field Background: Enter a custom expression.

   • Alignment: Select None (default), Center, Left, or Right.

   • Width: Enter either a specific width (in pixels) or Auto (to automatically size the column).

   • Header Group: Group consecutive columns together under a single heading.

     • For each field to be grouped together, select the field in the Columns pane and add the same Header Group name.

   • Evaluate After Filters: Select to calculate the value for a column with a formula only after filters have been applied.
     Example:

     • Load Port Days is a custom column that will be populated from the Port Days column.

     • Port Function is filtered on Load.

     • Load Port Days column has Eval. After Filters enabled.

     • Filters are applied before calculating the value of the Load Port Days column.

   • Hidden: Select to hide the column in the report output.

   • Hide if Empty: Select to hide the column in the report output if there are no values.

   • Is Multi-Line: Select to wrap the column value onto multiple lines when the column width is not sufficient to display the value.

3. To save the report, click << Report at the top of the Column Properties panel and then click Save.