Add Column

You can create calculated measures, dimensions, and conditional columns right within Infobridge and cascade them to target reports. The source report will remain unchanged; you can enhance it with the required dimensions and measures created in Infobridge. Let's explore the different options to create measures, dimensions, and columns within a bridge.

Add measure/dimension

1. Add Measure

Write a custom calculation or leverage built-in Infobridge formulas to create a measure. The formula editor opens when you click the Add Measure option. Add references to dimensions and measures from the Reference tab. Access built-in functions from the Function tab.

Adding a new calculated measure

Notice how a custom measure has been added to the bridge:

New measure added from Infobridge

2. Add Dimension

You can add dimensions directly in a bridge by writing an expression based on specific conditions, or applying calculations. Enter the expression in the formula editor.

Creating a dimension in Infobridge

ingA custom dimension is created in the bridge:

New dimension added from Infobridge

3. Split Column

Split a dimension column into multiple dimensions based on a delimiter or position.

Split option in Infobridge

In this example, the Benchmark dimension is a comma-separated field. We've used the delimiter option to split this field into 2 dimensions: Benchmark 1 and Benchmark 2.

Splitting dimensions in Infobridge

4. Conditional Column

Conditional columns are computed columns where the value is determined based on specific conditions or rules applied to other columns. It helps categorize data based on predefined criteria.

For instance, you can calculate the debt-risk level based on the Debt-to-Equity Ratio.

Sample conditional column

Similarly, you can assign a tax rate or shipping rate based on the region.

Sample conditional column for tax and shipping rates

Infobridge provides a no-code, intuitive interface to quickly create conditional columns. Let's add a new dimension to categorize regional markets.

Creating a conditional column in Infobridge

We've created the "Global Market" dimension using the conditional column option.

Dimension added in Infobridge using the conditional column option

Last updated

Was this helpful?