If your dataset includes dates, you have more options for manipulating your results by adding date-based attributes to your query. In addition to slicing your results by date, you can also limit your results to a selected date range or across a rolling period. For information on adjusting dates to match your calendar see, Modifying your calendar using fiscal attributes.
- Click on the added date attribute.
Editing date ranges
Once you have added a date attribute to your query, you can specify the period of time by editing the date range options. You can edit your date ranges by clicking on a date attribute, then selecting Edit date ranges
There are two types of date range options, Simple and Advanced. In the Simple panel, you can select from a list of named periods. You can also select the 'Custom' option to pick a specific calendar start and end date.
In the Advanced panel, you can choose separate beginning and end dates. For each beginning and end date you can select from a list of named periods, enter in a calendar date, view all history, or select a rolling period. In a rolling period, you can select options like seven days in the past or a year in the future.
You can also repeat the selected range Advanced > Add repeat pattern. The repeat option provides a more detailed comparison for period on period results. With the repeat option, you compare to exactly the same point last year. For example, if your range date is 'This year' to 'Today', and today is September 16th, a repeat pattern of 'one year in the past' will compare figures for this year with January 1st to September 16th of last year. Without the repeat option selected, the results would compare the figures for this year with the overall total of last year.
- Yesterday will show results for the previous day. This choice is ideal for web analytics or social media tracking.
- Yesterday (working day) will show either the previous day's results if the current day is between Tuesday through Saturday, or the previous Friday if the current day is a Sunday or Monday. This suits a Monday-Friday working week for sales teams, order processing, etc.
- Yesterday (workable day) will show the previous day's results if the current day is between Tuesday and Sunday, or the previous Saturday if the current day is Monday. This suits shops or call centers that don't operate on Sundays.