How to use the "Until" field

The Until field allows you to offset the selected Date Range(s) by a set amount. This is an advanced functionality in Databox. 

HOW TO

How to access the Until field

The "Until" field can be found in the  Advanced Settings window. Learn more here

How to use the Until field [Example]

In Databox, "This Year" is set to display data from January to December. It is currently only possible to report on fiscal or financial years in Databox using the "Until" functionality. 

Let's say our fiscal year goes from July 1st to June 30th. Follow the steps below to offset "This Year" to look at data for July through June. 

1
 In the Designer, add a Datablock to your Databoard. Select your Data Source, Metric, and This Year as the Date Range
2
 Open the Advanced Settings window
3
 If it is the first half of your fiscal year (i.e., July 1st through December 31st), enter  6 in the Until field. This will offset the January 1st start date to July 1st of the same year (6 months later). 
If it is the second half of your fiscal year (i.e., January 1st through June 30th), enter  -6 in the Until field. This will offset the January 1st start date to July 1st of the previous year (6 months earlier). 
Pro Tip: The Until field works in conjunction with the Granularity selection. If Granularity is set to Monthly, 3 will offset the Date Range by 3 months. If Granularity is set to Daily, 3 will offset the Date Range by 3 days
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us