What is the best way to take a metric and trend it by the lengths of time in the title of this post?
Bit vague question but I would guess using SET analysis and flags generated in a Master Calendar for the periods that you need.
Creating A Master Calendar
Set Analysis: syntaxes, examples
Retrieving data ...