Overview: Date Ranges

HOW TO

How to define Date Ranges

IN THIS

What are pre-defined Date Ranges?

Learn more about pre-defined Date Ranges here.

What are Custom Date Ranges?

Learn more about Custom Date Ranges here.

What are the parameters for each Date Range?

By understanding the parameters for each Date Range in Databox, you can build valuable reports to meet the needs of your company. The following Date Ranges are currently available in Databox:

Today	Yesterday	Last 24 Hours	Last 7 Days
Week to Date	This Week	Last Week	Last 14 Days
Last 28 Days	Last 30 Days	Month to Date	This Month
Last Month	Last 90 Days	Quarter to Date	This Quarter
Last Quarter	Last 180 Days	Year to Date	This Year
Last 12 Months	All Time

Today: from today (00:00) to the last data sync

Yesterday: from yesterday (00:00) to yesterday (23:59)

Last 24 Hours: from 24 hours ago to 1 hour ago

Last 7 Days: from 7 days ago to yesterday (23:59)

Pro Tip: On Charts like Line Charts and Bar Charts, "Today" is included. Because of this, you will see 8 days included in the Date Range for Charts.

Week to Date: from the first day of the current week (set in Databox Account) to the last data sync

This Week: from the first day of the current week (set in Databox Account) to the last day of the current week
The full week will be visible on a Chart only if data is available for future dates. Future dates will be displayed with a dotted line to highlight expected performance.

Last Week: from the first day of last week (set in Databox Account) to the last day of last week

Last 14 Days: from 14 days ago to yesterday (23:59)

Pro Tip: On Charts like Line Charts and Bar Charts, "Today" is included. Because of this, you will see 15 days included in the Date Range for Charts.

Last 28 Days: from 28 days ago to yesterday (23:59)

Pro Tip: On Charts like Line Charts and Bar Charts, "Today" is included. Because of this, you will see 29 days included in the Date Range for Charts.

Last 30 Days: from 30 days ago to yesterday (23:59)

Pro Tip: On Charts like Line Charts and Bar Charts, "Today" is included. Because of this, you will see 31 days included in the Date Range for Charts.

Month to Date: from the first day of the current month to the last data sync

This Month: from the first day of the current month to the last day of the current month
The full month will be visible on a Chart only if data is available for future dates. Future dates will be displayed with a dotted line to highlight expected performance.

Last Month: from the first day of the previous month to last day of the previous month

Last 90 Days: from 90 days ago to yesterday (23:59)

Pro Tip: On Charts like Line Charts and Bar Charts, "Today" is included. Because of this, you will see 91 days included in the Date Range for Charts.

Quarter to Date: from the first day of the current quarter to the last data sync

This Quarter: from the first day of the current quarter to the last day of the current quarter
The full quarter will be visible on a Chart only if data is available for future dates. Future dates will be displayed with a dotted line to highlight expected performance.

Last Quarter: from the first day of the previous quarter to the last day of the previous quarter

Last 180 Days: from 180 days ago to yesterday (23:59)
On Charts like Line Charts and Bar Charts, "Today" is included. Because of this, you will see 181 days included in the Date Range for Charts.

Year to Date: from the first day of the current year to the last data sync

This Year: from the first day of the current year to the last day of the current year
The full year will be visible on a Chart only if data is available for future dates. Future dates will be displayed with a dotted line to highlight expected performance.

Last 12 Months: from 12 months ago to yesterday (23:59)

All Time: from the furthest date data is accessible to the last data sync

How to add additional Date Ranges to a Datablock

Pro Tip: Currently, Advanced Tables and Multi-Tab Charts do not support multiple Date Ranges. Learn more about the capabilities of different Visualization Types here.

In the Designer, click on the Datablock you want to add additional Date Ranges to. This will open Datablock Settings

Click on the Date Range drop-down list

If the visualization support multiple Date Ranges, you can select up to 6 Date Ranges to set for the Datablock from this list

Pro Tip: To remove a Date Range from a Datablock, click on the x to the left of the Date Range in Datablock Settings.

In order to achieve your reporting objectives, you may need to expose more Date Ranges options for a Metric. For certain Data Sources, this is possible using Query Builder. Learn more here.

How to set the Primary Date Range for a Datablock

Learn how to set the Primary Date Range for a Datablock here.

How to switch between Date Ranges on a Datablock

To switch between Date Ranges on a Datablock, click on the drop-down arrow next to the Datablock Name. This will open the list of Date Ranges that have been selected for the Datablock.

Click on a Date Range from this list to switch the view on the Datablock.

This can be done in the Designer, Preview, or Streaming URL.

How to switch between Date Ranges on a Databoard

Learn how to change the Date Range for the entire Databoard here.