Using a Copy operator, we copy last year sales data to another KF (History 1y ago) in weekly buckets. Last year split week ( Week which runs between 2 months) got 2 days in one month & 5 days in another month and current year week splits like 3 days in one month and 4 days in another month, causing issues in data aggregation at monthly buckets for History 1Y ago KF. We use WEEKWEIGHT as our period weight factor to split the data for both KF’s. I am thinking of creating another period weight factor with weights as last year and update against History 1Y ago KF. Is there any better way to do this?
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.