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: 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 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 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 Last 180 Days: from 180 days ago to yesterday (23:59) 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 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 DatablockPro Tip: Currently, Advanced Tables and Multi-Tab Charts do not support multiple Date Ranges. Learn more about the capabilities of different Visualization Types here. 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 DataboardLearn how to change the Date Range for the entire Databoard here.
|