Weekly To Monthly Frequency
Posted: Thu Dec 05, 2019 8:36 am
Hello,
In the attached workfile I would like to convert the weekly time series into four or sometimes five monthly time series where each series contains the value of the respective week, i.e. series_first_week, series_second_week, ... .
So for January 1967 i would expect 208000 in the first week, 207000 in the 2nd week, 217000 in the third week, 204000 in the fourth week and 216000 in the last week of Jan. Is that possible?
Thanks a lot for your help.
Best wishes,
Günter
In the attached workfile I would like to convert the weekly time series into four or sometimes five monthly time series where each series contains the value of the respective week, i.e. series_first_week, series_second_week, ... .
So for January 1967 i would expect 208000 in the first week, 207000 in the 2nd week, 217000 in the third week, 204000 in the fourth week and 216000 in the last week of Jan. Is that possible?
Thanks a lot for your help.
Best wishes,
Günter