HOW TO
- Define Date Ranges
- Set the Primary Date Range for a Datablock
- Switch between Date Ranges on a Datablock
- Switch between Date Ranges on a Databoard
How to define Date Ranges
IN THIS
- What are pre-defined Date Ranges?
- What are custom Date Ranges?
- What are the parameters for each Date Range?
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
Pro Tip: 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
Pro Tip: 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)
Pro Tip: 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 10 years ago to 2 years in the future for custom integrations, and from 36 months ago to the last data sync for native integrations. This is dependent on the availability of data for the metric, as certain metrics may have less historical data available
The amount of historical data you're able to access in Databox is dependent on your Databox plan. 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 above 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.
- Click on the Graph by to open a list of graph visualizations for your Datablock. "Graph by: Day" will plot daily data on the chart, "Graph by: Month" will plot monthly data on the chart, etc. Select an option from this list to switch the view on the Datablock.
- You can use the Cumulative toggle to display a cumulative graph.
Pro-Tip: For certain Metrics and Date Ranges, the Cumulative option may be disabled because it would necessitate adding together unique values and would produce inaccurate data.
Pro-Tip: You can switch the Date Range on a Datablock in the Designer, Full Screen-View, or in the Streaming URL.
How to switch between Date Ranges on a Databoard
Learn how to change the Date Range for the entire Databoard here.