Sliders in Scenario Manager

Basic overview

AVAILABLE SINCE 3.8.0

Sliders in the Scenario Manager allow you to modify existing Line-Items with the ease of a Slider without having to enter the Line-Item data itself.

Preparation

1. Add a resizable Scenario Manager to a Sheet with the Charts you want to see get updated. Click on the dropdown next to the 'Chart' button and choose Scenario Manager. A resizable version of the Scenario Manager will appear.

2. Show the columns "Change" and "Before/After" in the Scenario Manager. The Slider will appear in the "Change" column and the original and resulting value will show in the "Before/After" column.

3. Which Line-Items do you want to display Sliders for? Sliders are only displayed for Line -Items with only one row. Filter your Line-Items with the Reconfigure > Manage Filters dialog to one row. The Slider should now appear.

4. Set the minimum, maximum, and the step size in the 'Details' tab of the Line-Item. e.g. a minimum of -100, a maximum of 100, and a step size of 25 will produce a Slider like below. You will only be able to choose the values -100, -75, -50, -25, 0, 25, 50, 75, 100.

Line-item variants

Sliders cannot be used for Line-Items that have more than one Variant.

Working with the Sliders

Now you can change the Slider and see the effects in your Charts. Changing the Slider will change the data in the Line-Item so all your changes are saved like before.

How to use the Slider for Line-Items with multiple rows

If you want to have a Slider that distributes a Value over multiple years (e.g. total turnover for 2020-2023) or copies a Value to multiple years (e.g. inflation % for 2020-2023), then you have to build that logic in the Model. Build the Node in such a way that it takes only one Value as input and the following Node can then distribute or copy it over a Dimension.

Resetting the Sliders

If you want to reset all Sliders, click on the three-dot menu in the change column