Overview: Date Ranges

HOW TO

• Define Date Ranges
• Add additional Date Ranges to a Datablock
• 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 the parameters for each Date Range?

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

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 Lucrative.ai Account) to the last data sync

This Week: From the first day of the current week (set in Lucrative.ai 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 Lucrative.ai 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

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

2- Click on the Date Range drop-down list

3- 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

How to set the Primary Date Range for a Datablock

Learn how to set the Primary Date Range for a Datablock

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.