I want statistics (e.g. median, mean, etc.) on my data by various time intervals: day, week, month, year, etc. Two niggly questions:
If I have a single time column, is the interval used for grouping sensitive to the column format? i.e. if the format to "m/y", does it group by months? If I then change the column format to "m/d/y", does it now group by days?
If not, then I can certainly use the Day of Year() and Week of Year() functions. But of course these reset to 1 at the beginning of each new year, and my data spans multiple years. I've fiddled around with various solutions, but none of them are as elegant as I'd like. What have you found to be the cleanest way of grouping multi-year data by weeks, months, quarters and years?