Skip to main content
Skip table of contents

Year-over-Year Bridge (YoY)

In this article, you will find a tutorial on how to create YoY Bridges, as well as an explanation of their calculation logic.

A Year-over-Year Bridge shows the change between two periods using the effects of assumptions. In contrast, a Scenario Bridge can be used to analyze the change between two different scenarios in a specific period.

Creating a YoY Bridge

Use the tile chart wizard to create a new YoY bridge. After selecting the node you want to analyze, the bridge will be created. 

Configuration Options:

  • Node: The bridge always displays values for a selected node in the model. You can change the node after the bridge is created by selecting a different node in the Inspector.

  • Scenario Selection: By default, a single scenario will be selected for the bridge. If you have scenarios building on top of each other, e.g. a base-case and simulation scenarios, you can select additional scenarios using the scenarios button in the settings. Remember to bring the scenarios into the right order using Sort and Format. The first scenario will be used as the foundation for the effective calculation of the second scenario, therefore potential differences between the selected time period in the underlying scenario will be shown as the first entries in the YOY bridge.

  • Levels: You can use the “Manage Filters” setting to add any level to your chart. By default, the bridge will be created with the level “Years”. To change to a different period select Configure Axes and swap "Year" for the desired time level (e.g. "Quarter" or "Month"), if its available.

  • Period Selection: Depending on the chosen time level for the bridge, a filter for each level, e.g. Years can be set after clicking on the level. You can use this filter to select the two periods the YoY bridge should show. Selecting e.g. 2017 and 2020 will result in a bridge with the summed-up effects of the three years.  In case only a single period is selected, the bridge will automatically use the previous period as a reference point for the YoY bridge. 

You can switch between scenario and YoY bridges by using the option Bridge between periods in the Bridge Settings.

Calculation Logic

To illustrate the calculation logic behind the effects of individual assumptions, let's consider the simple example of the node “Revenue”. Adjustments can be made using assumptions with a base effect, which means that the adjustment is carried into the following years. Alternatively, assumptions can be one-time adjustments without an effect on the following years. 

Assumptions without base effect / one time:

2017

2018

2019

Assumption 1 (no base effect)

+10

+15

+20

Assumption 2 (no base effect)

-

+20

-

Revenue

10

35

20


Assumptions with base effect:

2017

2018

2019

Revenue PY

-

20

35

Assumption 3 (with base effect)

+10

-

-

Assumption 4 (with base effect)

+10

+15

+20

Revenue

20

35

55

The calculation logic determines the individual effects for all assumptions that are active in the selected scenario between the two viewed periods.
A YoY bridge for 17/18 or 18/19 would display the following effects:

YoY Effect 17/18

YoY Effect 18/19

Assumption 1 (no base effect)

+5

+5

Assumption 2 (no base effect)

+20

-20

Assumption 3 (with base effect)

0

0

Assumption 4 (with base effect)

+15

+20


Contact 

You may contact the Valsight Customer Support via:

+49 30 46799042

support@valsight.com

Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .

*Except Public holidays in Berlin, Germany.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.