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:
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 syncYesterday: from yesterday (00:00) to yesterday (23:59)Last 24 Hours: from 24 hours ago to 1 hour agoLast 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 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.