what-if scenario

#1

Does Dundas have any “what-if scenario” functionality? I can’t seem to find anything on this in the documentation. Basically, I want the user to be able to enter in a number value and then have this value be used in a table. This number can be any decimal value so a fixed list doesn’t really work.

So, simple example of the dashboard is a table visualization where EndResult = Sales x Multiplier

Date Sales Mult EndResult
Jan 100 5 500
Feb 20 5 100
Mar 30 5 150
Apr 50 5 250

The table will default with an original Mult value (always the same value) and then I want a textbox where if the user enters in a number and clicks a button, the table will change calculations based on that input value.

User input: 2
table changes to:

Date Sales Mult EndResult
Jan 100 2 200
Feb 20 2 40
Mar 30 2 60
Apr 50 2 100

I don’t need to actually see the Mult column. The input value can be any decimal.

Anyone done something similar? Thanks.

#2

Hello,

Yes Dundas BI supports what-if scenarios. One of the most common ways to set this up is to use Formulas. There’s an introduction video available here.

In your specific case I think you’d want a Formula with a Formula Placeholder. You can find more information about how to add that here.

Once you’ve added the parameter placeholder you can add a Filter->Single Number and attach it to the parameter placeholder you created in your formula. This way a user viewing your dashboard can enter the value they want and have the formula update in the visualization.

1 Like
#3

@terrence, the Formula with a Formula Placeholder is exactly what I needed. I couldn’t find it with what I was calling it so thanks for the document reference. I knew Dundas wouldn’t let me down. Thanks again!

2 Likes