Here are some tips that I recall.
The main thing to remember it to keep things consecutive and to not have gaps.
Each defined bucket of time has to have a range of integers that is consecutive and spans the entire date ranges of your time profile.
The start date should typically be like YYYY-MM-DD 00:00:00
The end date should typically be like YYYY-MM-DD 23:59:99
Date ranges cannot overlap another period within the same time bucket (month,quarter,year)
So lets say you want a 3 year span, with month quarter and year buckets. Starting in Jan 2015, ending Dec 2017.
I'd start your csv file with the list of months.
We grouped our integer ranges by 1000's
So 1001 would represent January 2015 with a start date of 2015-01-01 00:00:00 and an end date of 2015-01-31 23:59:99.
Then list out the rest of the 36 months.
The ID of 1036 would represent Dec 2017 with a start date of 2017-12-01 00:00:00 and an end date of 2017:12:31 23:59:99.
Then you'd list your quarters, with the 1000's numbering convention you'd start with 2001.
ID 2001 would represent Q1 2015 with a start date of 2015-01-01 00:00:00 and an end date of 2015-03-31 23:59:99.
Then list out the rest of the 12 quarters.
ID 2012 would represent Q4 2015 with a start date of 2017-10-01 00:00:00 and an end date of 2017-12-31 23:59:99.
Then jump to the 3000's for the years.
ID 3001 for 2015, ID 3002 for 2016, and ID 3003 for 2017 with the appropriate date ranges.
Notice each time category/bucket has the exact same start for its first periodid and the exact same end date for its last periodid. This is because each category/bucket spans the entire range of your desired profile.
Hopefully this helps you get past your issues. Let know if you still are having issues and on Monday I'll post the csv file for our time profile.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.