What if analysis dashboard

Balance Sheet. Cash Flow. Human Resources Headcount. Procurement Purchasing. Contract Management. Inventory Management. General Services Service Management. Travel Management. Project Management. We are interested in creating a what-if analysis that shows how our sales would change if they improved by 0 — percent. There are couple of ways to write this calculation; here is one:. Notice that parameters are colored purple and can be used in a formula just like any other field in your calculation.

Now that we have our parameter in a calculated field, we can use it in a view. To create two lines on the same axis, one for actual sales and one for what-if sales, we will drag our newly created calculated field onto the existing axis for sales. For this view, we have changed the colors of the measure names and placed the line for what-if sales on top of actual sales by dragging what-if up in the Measure Names legend. At this point, your view should look like this:. There is one last step needed in order to utilize your parameter.

Notice that the inputs available are the ones that we set up when we first created the parameter; a range of zero — in increments of five. For additional ways to provide interactivity to your end users, see tip eleven in our Data-Driven Storytelling series, Allow Discovery. By entering your email address, you consent to receive communications from Evolytics. Technical Articles Prasanth S. March 10, 1 minute read. Case: Generally, while performing a What If Analysis we need a scenario which helps us in pertaining the changes in the outcome of the model.

And I have mapped the cell to a Spinner Component as shown below In this way I have used Gauge and Spinner components to predict the outcome for the input entered by the user. Please refer the sample working video. It is time consuming to manually update all the feature values in a scenario. You can copy rows from a DSS dataset into the interactive scoring tile to create a scenario.

In the interactive scoring tile, click … and select Paste features , then follow the instructions in the dialog. Product documentation on interactive scoring. How to create a Jira issue automatically upon a DSS scenario execution failure Can I control which datasets in my Flow get rebuilt during a scenario? You are viewing the Knowledge Base for version 9.