Skip to Content
Former Member
Jul 01, 2011 at 12:56 AM

Need suggestion in doing functionality similar to What-if Analysis?



I have to develop a line chart with some requirements which is little bit tricky. So, was checking out if some one can help me out here. My scenario is explained below:

Suppose if you are a Oil drilling machinery supplier and you receive invoices for drilling machine order from your clients every month. Now last year because of the issue like BP oil spill in gulf of mexico, and this year Japan's Tsunami the client has not received many invoices from oil drilling companies which are working in those areas.

So my invoices numbers are like in Feb 2010 was 10000, in March 2010 was 11000, and in April 2010 was 11500, and after the incident in April 2010 the May 2010 values are 5000, June values are 5500, July is 5700, and August 2010 is 10300.

Same kind of deviated values happened after Japan Tsunami. ( i have just taken these examples to let you understand my problem clearly).

Now with the deviation in invoices after April 2010, and the business restoring to its normal sales after 4-5 months, let us assume that June 2011 invoices are 11900.

Now my user wants to see a line chart in which he will have last six months of data (Dec-2010 to May-2011). Now they want to have another series in the chart which is a prediction of the future three months values. Also they want an option where in they want to see if some disaster happens what could be the drop in their invoice numbers.

For the first prediction i think i can use Trend Analyzer and forecast it to three months by feeding the last 6 months of data and use the resultant values in the series. But for the second scenario what can i do to retrieve a deviation in values.

Please let me know if you need any other details here.