Add Column

Add columns in Infobridge#

Use transformation commands on the Transform ribbon to create calculated measures, dimensions, split columns, and conditional columns. These transformations enrich bridge data without modifying the source report and cascade to downstream reports.

Open transformation commands#

After creating a bridge, open the Transform tab to access data transformation options.

The Transform ribbon provides these commands:

• Add Measure
• Add Dimension
• Split Column
• Conditional Column

Add a measure#

Use Add Measure to create calculated measures with expressions and built-in functions.

The following example creates a measure named Gross Profit Margin (%) that calculates profit as a percentage of sales.

1. On the Transform ribbon, select Add Measure.
2. Enter Gross Profit Margin (%) as the measure name.
3. Select Formula.

4. Enter the following expression:

   ("Sum of Profit" / "Sum of Sales") * 100

5. Select Apply.

The new measure appears in the bridge and is available for reporting and other transformations.

Add a dimension#

Use Add Dimension to create new dimensions with expressions and conditional logic.

The following example creates a Profit Rating dimension that categorizes records based on profit values.

1. On the Transform ribbon, select Add Dimension.
2. Enter Profit Rating as the dimension name.
3. Create a CASE expression that evaluates profit ranges and returns a category.
4. Select Apply.

Example logic:

CASE
WHEN "Sum of Profit" < 1000 THEN 'Decommission'
WHEN "Sum of Profit" > 1000 AND "Sum of Profit" < 5000 THEN 'Break even'
WHEN "Sum of Profit" > 5000 AND "Sum of Profit" < 10000 THEN 'Average Sales'
WHEN "Sum of Profit" > 10000 THEN 'Target achieved'
ELSE 'N/A'
END

The new dimension appears in the bridge.

Split a column#

Use Split Column to divide a dimension into multiple dimensions with a delimiter or character position.

The following example splits the comma-separated values in the Market & Geography column into separate columns.

1. On the Transform ribbon, select Split Column.
2. Select Market & Geography as the target column.
3. Select By delimiter as the split type.
4. Enter a comma (,) as the delimiter.
5. Select Apply.
   

The transformation creates separate columns for each value segment.

Add a conditional column#

Use Conditional Column to create values based on business rules and conditions.

For example, a conditional column can categorize records into risk levels, regions, business segments, or other classifications.

Example: Categorize debt-to-equity ratios

The following example categorizes debt-to-equity ratios into risk levels.

Example: Assign tax and shipping rates

The following example assigns tax rates and shipping rates based on region.

Create a conditional column

Use conditional logic to create a Global Market column based on country values.

1. On the Transform ribbon, select Conditional Column.
2. Enter Global Market as the column name.
3. Configure the required conditions and output values.
4. Optionally define a default value in the Else section.
5. Select Apply.

The new conditional column appears in the bridge.