Data Aggregation in Time Series

[vkarthi8]

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. 

[DataNath · Accepted solution]

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:

[Kakuffo]

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

[vkarthi8]

@DataNath , this solution worked for me.. Thank you

[vkarthi8]

@Kakuffo Thank you for your support ..