Sliders in Scenario Manager

Basic overview

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 “Slider” column in the Scenario Manager. The Slider will appear.

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 via ‘Details’ > ‘Manage filters and levels’ to one row. The slider should now appear.

4. Set the minimum, maximum, and the step size in the 'Details' 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.

Sliders in Tiles

Sliders are now also available to be displayed in tiles on a worksheet. This allows faster and more focused simulations as sliders can be separately added for each line-item or with all relevant sliders in one tile.

To add a slider tile to your worksheet, add a chart to your workspace and select “Slider” in the chart type selection.

Settings for Sliders in Tiles

• Via the edit button, the line-items for which sliders should be shown can be adjusted

• Via the settings, the slider tiles can be renamed, moved and duplicated or deleted

• Via the settings, the before/after column can be turned on for the slider tiles, visualising the impact of the slider value

• Resetting sliders

  • Resetting all slides in a tile is possible via the settings

  • Resetting a single slider is possible via the reset button on the right of each slider

Limitation

• Sliders cannot be duplicated or moved to other workspaces

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-tiem 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 or the three dot menu on the slider tile itself.