Skip to Content

Simple steps to Understand about WHAT-IF ANALYSIS

WHAT-IF analysis means the study of how model output varies with changes in input.

Below are the simple steps, by using which you can create a Dashboard using WHAT-IF Analysis:-

1) First you have drag below component to Canvas:-

I) A Bar Chart

ii) A Pie Chart

iii) A Gauge

iv) A Panel Container which consists more than one Horizontal Slider


2) Come to Spreadsheet:-


3)  Properties of Bar Chart:-


4) Properties of Pie Chart:-


5) Properties of Horizontal slider:-


6) Properties of Gauge:-


7) After execution before changing WHATIF Analysis:-


8) After changing vale of Pencil, the overall values are changes. Follow the Screenshot:


9) After changing all the values of Horizontal slider (Pencil/Pen/Bags/Books), follow the changes which shown in the below screenshot:-


Hope this helps….



You must be Logged on to comment or reply to a post.