Hi, I am working on a retail POC which is based on daily sales. The modules I've created contain a Day timescale which works fine. However, I don't seem to be able to create a Time Period Format that contains days. Week seems to be the lowest level. What I am trying to achieve is to lookup sales from a Day in the previous year as a baseline for a given day in the current budget. The business look for a date in the prior year to correlate expected sales based on day of the week, time of year and promotional activity. For example, the baseline Sales Budget for say 1/7/2015 will initially refer to 1/7/2014 (simple 1 year lag), however the business may want to adjust this to 2/7/2014 to align Wednesday to Wednesday (ie. lag +1). However, promotional activity will mean that this 'lag' is not constant. For example, the following Monday 6th July 2015, let's say they plan for a 1 week promotional sale. When they look back at the prior year, they determine the promotion started a week later. Therefore the the correlating dates for this week to lookup sales from the prior year will be 14/7/2014 to 20/7/2014. Essentially the business want a Date overwrite option to lookup any given days sales in the prior year. This is done at the Country Level and then pushed down to all stores in that country. I don't seem to be able to get this to work without the Day being available in the Time Period Format. I'd be grateful for any suggestions. Thanks, Chris
... View more
