How can I create a predictive month and Week with Linest_m function ?

[#1]

Hi all,

I want to create a predictive month and week with the linest function Linest_m for the 2014 and 2015 year.

How can I achieve it ?

Thank for your help.

[MarcoWedel]

please describe your data and the result you are looking for.

regards

Marco

[#3]

Hello Marco,

I have a sample table with

CalendarDate represents the day where the Emp_Id is active

Emp_Id is an employee Code

Termination is a flag who the employee left the enterprise

Hired is flag where the employee is active

I want to create a bar chart  with my turnover expression for 2015 and MonthNum.

When I select 2015 year in bar chart I want to have the twelve months and my turnover expression.

If months don't exist then I calculate a forecasting turnover until end  month for 2015.

jan. - 0.65%

feb. - forecasting To

mar. - forecasting To

apr. - forecasting To

may. - forecasting To

jun. - forecasting To

jul. - forecasting To

aug. - forecasting To

sept. - forecasting To

oct. - forecasting To

nov. - forecasting To

déc. - forecasting To

Is it possible to have this same chart by WeekNum ?

Thanks.

[#4]

Hello Marco,

Have you enough information about the manner to calculate a forecasting month and week for 2015 ?