Select Date Ranges

Optimize your reports with tailored Date Ranges for precise analysis, and leverage them to compare data across various timeframes, identifying trends and gaining valuable insights.


Availability

profile  All user roles

box  All accounts

lock  One or more features exclusive to select subscription plans


 

Date Ranges specify the time period for which data will be extracted, aggregated, and presented to you. It allows you to focus your analysis on relevant timeframes and compare data across different periods. In Databox, Date Ranges are configurable through predefined options and custom selections, facilitating tailored reporting based on the temporal context of the data.

dr2 dr3 dr4 dr5
dr6 dr7

Select a Date Range

The Date Range selector in Databox is standardized across the application, offering a variety of options categorized into five groups, as outlined below.

Popular

  • Week-based: Week to Date, Last Week
  • Month-based: Month to Date, Last Month
  • All Time

lock Current

These Date Ranges include the current day and time, allowing you to analyze ongoing periods. Available options include:

  • Today
  • This <period> (e.g., This Week, This Month)
  • <period> to Date (e.g., Year to Date)

lock Previous

These Date Ranges focus on past periods and do not include the current day unless explicitly specified. You can customize Last... and Since... Date Ranges to include or exclude the current period. Examples include:

  • Yesterday
  • Last <period> (e.g., Last Week, Last Month)
  • Last <X> <period> (e.g., Last 7 Days)
  • Since <date> (e.g., Since 5 July 2024) New!

lock Future

These Date Ranges begin in the future, helping you to plan and forecast. Examples include:

  • Tomorrow
  • Next <period> (e.g., Next Week, Next Month)

 lock Custom

Custom Date Ranges allow you to set any fixed or rolling period between two days of your choice. Rolling periods automatically adjust start and end dates relative to the current date. For example:

  • On July 5th, a Custom Date Range is set from June 7 to June 13.
  • On July 6th, the Date Range will automatically adjust to display data from June 8 to June 14.

Date Range definitions

The table below details the start and end dates for each Date Range option, including any available customization settings. Dates and times are based on the time zone specified in the Data Source settings.

Date Range Start Date* End Date*
Today 12:00 am of today

☐ Include future: start of next hour

☑ Include future: 12:00 am of tomorrow

This <period> 12:00 am of the first day 12:00 am of the day after last
<period> to Date 12:00 am of the first day Start of next hour
Yesterday 12:00 am of yesterday 12:00 am of today
Last <period> 12:00 am of the first day

☐ Include <period>: 12:00 am of the day after last of the previous period

☑ Include <period>: 12:00 am of the first day in the next period

Since <date> 12:00 am of the chosen date

☐ Include today: 12:00 am of today

☑ Include today: 12:00 am of tomorrow

Tomorrow 12:00 am of tomorrow 12:00 am of the day after tomorrow
Next <period> 12:00 am of the first day 12:00 am of the day after last
Custom 12:00 am of the first day 12:00 am of the day after last
All Time

12:00 am of the first day 10 years ago**

12:00 am of tomorrow 2 years into the future**

12:00 am of the first day 3 years ago

Start of next hour

*  Start dates are inclusive and end dates are exclusive, i.e. Start Date ≤ Date Range < End Date.

** Databases, spreadsheets, automations, and data sent via our REST API.

magic-wandTip: You can specify which day should be set as the first day of the week in your account settings.

Frequently Asked Questions

Is it possible to adjust the Date Ranges to match my company's fiscal calendar?

Yes, Databox supports fiscal calendars with customizable year start and end dates, quarter start and end dates, and week-aligned calendars. For more information on how to enable this feature, please refer to our pricing page.

Why am I not able to see historical data for a Metric?

Every metric in our system is optimized to retrieve data according to the source integration's technical specifications. Certain parameters, such as historical data availability, may be limited by the source and are beyond our control. For detailed information on specific integrations and metric implementations, please refer to the Metric Library.

Why can't I select certain Date Ranges?

The availability of Date Ranges depends on your subscription plan. If you select a Date Range that includes periods outside the historical data available in your plan, it will be automatically disabled. For example, with the Starter plan, you cannot select "Last Year" or "Last 12 Months" because this plan is limited to the latest 11 months of historical data.

Why is the weekly data in Databox not accurate despite having the first day of the week properly set in my account?

Some integrations only provide data grouped or aggregated in predetermined weekly periods, e.g. as starting on Monday and ending on Sunday. In such cases, it is not possible to break down this data into granular values and recalculate it according to new criteria.

Still need help?

Contact us here or start a chat in Databox.