October 29, 2014 at 1:15 pm
All,
Attached is a file that generates a sample dataset from which I want to forecast a value for column 'Parcel Count 2014' from tomorrow (30/10/2014) till the end of December (31/12/2014). The forecast should be based on values from column 'Parcel Count 2013' for the same Month.
Please help me write this T-SQL.
Thanks,
J.
October 30, 2014 at 2:45 am
This was removed by the editor as SPAM
October 30, 2014 at 3:05 am
I was hoping to calculate that on the 2013 figures and maybe add a 5% increase for this year,is that possible? the forecast is seasonal and the last quarter retailers are expected to sell more online. Please note that the sample data is about number of parcel bought online.
October 30, 2014 at 3:22 am
This was removed by the editor as SPAM
October 30, 2014 at 3:34 am
Thank you but it is not what I want. You have projected all the 2014 values based on the 2013 values. I only want the 2014 projection to start from tomorrow until the end of December. All the values I already have for 2014 (I would normally have till today) comes from the database so they should stay as they are.
October 30, 2014 at 3:51 am
This was removed by the editor as SPAM
October 30, 2014 at 4:05 am
This does not work. The calculation is still being applied on all rows for 2014.
October 30, 2014 at 4:12 am
This was removed by the editor as SPAM
October 30, 2014 at 4:19 am
I think that will work if set this as a sub query and inner join with the dataset on TheDate.
Thank you.
October 31, 2014 at 1:42 pm
Here is another alternative..
select TheDate
,TheMonth
,WeekName
,ParcelCount2013
,case when TheDate is not null and TheDate > '2014-10-02' and TheDate < '2015-01-01' then ParcelCount2013 + ((ParcelCount2013 * 5)/100) else ParcelCount2014 end as Parcel_Count_2014
from d
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply