'Correct' monthly aggregation of weekly amounts

[#1]

Hi,

I´ve weekly amounts (e.g. Week 40: 15) and I want to aggregate these on a daily basis to a correct montly value. How can I achieve this in a elegant manner?

Thanks for yout ideas in advance...

Thorsten

[#2]

Hi Thorsten

the best way is to store your data at day level.

Then when you sum at weeks or months it will give you the right aggregated result because each day will be calculated in regard of according week and month

Best regards

chris

[#3 · Accepted solution]

I´ve found a solution by assigning 1/5 of the weekly amounts to each weekday (mo-fr)

starting by get the weekstart-date for the given week/year, I generate the necessary dates in a for...next loop...

here are the associated scriptcode