Data Aggregation in Time Series
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have Daily Input details with dates and amounts paid for 3 types of expenses - A,B &C. I use ETS model to run the forecast for these expenses and the results are given as daily forecast.
Can anyone assist me, with ETS model, how to aggregate these daily forecasted expenses into monthly/month-wise forecast.
Solved! Go to Solution.
- Labels:
- Time Series
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @vkarthi8 you could do something like this whereby you extract the month from each date:
Then you can use a Summarize tool to group by each month and therefore aggregate up as you wish. Here I've just taken the Average of each month but you can use Sum/Min/Max etc. as well:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @vkarthi8 Without seeing your data its quite hard to say but could always aggregate the data up to a month level total for each type of expense.
You can extract the month and the year from the date datatype using the date time functions in the formula tool. This allows you to group on a monthly/yearly level Then use this to create your predictions that way the entries would be per month rather than per day.
ETS will still provide the forecasts as normal
---Update what @DataNath has kindly produced for you is exactly my thinking
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DataNath , this solution worked for me.. Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Kakuffo Thank you for your support ..
