As soon as get to (Sunday), I’m in a new week - a week that ends on. The same holds true for Wednesday (1/16), Thursday (1/17), Friday (1/18), and Saturday (1/19). In the example above, is a Tuesday that falls in a week that ends on Saturday. Sometimes, I work with that data at a daily level, but, often, I want to roll the data up by week, by month, or by some other time period.įor instance, if I want to look at the data weekly, I’ll use either the last day of the week or the first day of the week and then use a formula in a new column to convert each actual day to the “week” in which it falls: I often find myself getting data out of one system or another (or multiple systems, and then combining them) as “daily” data - a series of metrics by day for a sequence of days.
Originally written by Analytics Demystified on January 15, 2013
