Preset Time Ranges

The following table describes all the preset time ranges available in Composer.

Preset type Data Cached? Start date End date
Current Hour No Beginning of the current hour Current time
Current Minute No Beginning of the current minute Current time
Current Month No First day of the current month (for example, 08/01/2018 12:00:00 AM) Last day of the current month (for example, 08/31/2018 11:59:59 PM)
Current Month-to-Date No First day of the current month (for example, 08/01/2018 12:00:00 AM) Current date and time
Current Quarter No First day of the current quarter (for example, 07/01/2018 12:00:00 AM) Last day of the current quarter (for example, 09/30/2018 11:59:59 PM)
Current Quarter-to-Date No First day of the current quarter (for example, 07/01/2018 12:00:00 AM) Current date and time
Current Week No Sunday of the week with current day (for example, Sunday, 08/16/2018 12:00:00 AM) Saturday of the week with current day (for example, 08/22/2018 11:59:59 PM)
Current Week-to-Date No Sunday of the week with current day (for example, Sunday, 08/16/2018 12:00:00 AM) Current date and time
Current Year No First day of the current year (for example, 01/01/2018 12:00:00 AM) Last day of the current year (for example, 12/31/2018 11:59:59 PM)
Current Year-to-Date No First day of the current year (for example, 01/01/2018 12:00:00 AM) Current date and time
Max Available Range No Minimum time value in the data set known to Composer Maximum time value in the data set known to Composer
Previous Hour No Beginning of the previous hour (for example, Aug 20 2018 12:00:00 PM) End of the previous hour (for example, Aug 20 2018 12:59:59 PM)
Previous Minute No Beginning of the previous minute End of the previous minute
Previous Month Yes First day of the previous month (for example, 07/01/2018 12:00:00 AM) Last day of the previous month (for example, 07/31/2018 11:59:59 PM)
Previous Month-to-Date No First day of the previous month (for example, 07/01/2018 12:00:00 AM) Same date and time last month (for example, 07/20/2018 1:00:00 PM) or the last day of previous month (if, for example, today is 07/31/2018 1:00:00 PM, the end date will be 06/30/2018 11:59:59 PM)
Previous Quarter Yes First day of the previous quarter (for example, 04/01/2018 12:00:00 AM) Last day of the previous quarter (for example, 06/30/2018 11:59:59 PM)
Previous Quarter-to-Date No First day of the previous quarter (for example, 04/01/2018 12:00:00 AM) Same date and time last quarter (for example, 07/20/2018 1:00:00 PM) or the last day of corresponding month last quarter (if, for example, today is 07/20/2018 1:00:00 PM, the end date will be 06/30/2018 11:59:59 PM)
Previous Week Yes Sunday of the previous week (for example, 08/09/2018 12:00:00 AM) Saturday of the previous week (for example, 08/15/2018 11:59:59 PM)
Previous Week-to-Date No Sunday of the previous week (for example, 08/09/2018 12:00:00 AM) 7 days before current day (for example, 08/132018 1:00:00 PM)
Previous Year Yes First day of the previous year (for example, 01/01/2018 12:00:00 AM) Last day of the previous year (for example, 12/31/2018 11:59:59 PM)
Previous Year-to-Date No First day of the previous year (for example, 01/01/2018 12:00:00 AM) Same date and time last year (for example, 08/20/2018 1:00 PM)
Rolling 7 days No 7 days before the current date and time Current date and time
Rolling 24 hours No 24 hours before the current date and time Current date and time
Rolling 30 days No 30 days before the current date and time Current date and time
Rolling 90 days No 90 days before the current date and time Current date and time
Rolling 365 days No 365 days before the current date and time Current date and time
Rolling Hour No 60 minutes before the current date and time Current date and time
Rolling Minute No One minute before the current date and time Current date and time
Today No Start of the current day (for example, 08/20/2018 12:00:00 AM) Current date and time
Yesterday Yes Beginning of the previous day (for example, 08/19/2018 12:00:00 AM) End of the previous day (08/19/2018 11:59:59 PM)