2 Replies Latest reply: May 21, 2017 7:12 AM by Stefan Wühl

Calculation for prediction

Hello,

I need help regarding prediction values. I describe my case briefly :

I have some TestObject and their Estimatedvalue are calculated. then from the value they can be sell in one or two steps with estimated efficiency.

Then I want to have the predicted sale in future by sum (Estimatedsale*EstimatedValue) in each month from different TestObject and plot them.

TestObjectEstimatedValueEstimatedsale1EffectMonthEstimatedsale2EffectMonth
A7,20,82017-040,22017-07
B60,32017-060,62017-09
C8,10,52017-090,4
D8,50,72017-050,2
E40,62017-060,42017-09
F5,70,52017-060,32017-07
G7,80,42017-090,4
• Re: Calculation for prediction

In theoretically, I got understand. when practical comes i need expected result as well. Is that possible to show expected outcome?

• Re: Calculation for prediction

You could transform your data in a table that only shows a single effect month:

EstimatedValue,

Estimatedsale1 as Estimatedsale,

Date#(EffectMonth,'YYYY-MM') as EffectMonth,

'1' as Step

FROM

(html, codepage is 1252, embedded labels, table is @1);

CONCATENATE

EstimatedValue,

'2' as Step,

Estimatedsale2 as Estimatedsale,

Date#(EffectMonth1,'YYYY-MM') as EffectMonth

FROM

(html, codepage is 1252, embedded labels, table is @1);

Then you can use this EffectMonth as dimension: