Date Picker (Datablocks)
- Arielle Kaye Odeste
Analytics
Overview / Description
Date Picker datablock provides a date filtering mechanism for reports or entire page by linking date picker to other reports on the page.
Common Use Case
Date Picker is used to filter reports by a set or custom date range to analyze/narrow down existing reports based on that time range.
Prerequisites
Dimension for linking is a prerequisite for the date picker. It allows you to specify the time to filter it.
All cube reports and status datablocks require a Dimension for linking. This setting can be found under the Options when creating a cube report.
By default, “DefaultDateSlicer” will be used. This config can be found under following eMite installation folder - D:\Program Files (x86)\eMite\6.0.2\config\DashboardAPI
"DefaultDateSlicerName": "[StartDate].[Date]"
Add Date Picker to a Page
1. Select the page where you want to add a datablock. In this example, Training Demo page is selected.
2. From Edit Page menu, select Add Content.
The Add Content setting will display.
3. Input the number of datablocks you want to add to the page, then click Add.
The Select Datablock sub-setting will display.
4. Select Date Picker from the datablock options.
5. Update the Datablock Title and Datablock Style accordingly.
6. Click Add.
The added datablock will display on the page.
7. Under Edit Page menu, select Save Page to save the datablock in the page.
Once the changes have been saved, a success message will display on the top right corner of the screen.
Link Date Picker to Another Datablock
A Date Picker can be linked to a number of report datablocks on your existing dashboard/page.
In this example, the date picker will be linked to the existing cube report in the page.
1. On the datablock header, click the Link icon.
The Link Targets window will display.
2. Select the datablock to where you want to link the date picker.
3. Click Link.
The date picker is now linked to the selected cube report.
4. Under Edit Page menu, select Save Page to save the changes in the page.
To check if the link is working, use the date picker to filter the displayed data on the linked cube report.
5. Select a filter from the date dropdown options.
6. Click Filter.
The displayed data on the linked cube report will update according to the selected date filter.
The applied date filter on the linked datablock is displayed on the datablock’s header.
Date Picker Options
Date Options | Description |
|---|---|
Custom | This is a custom date field specified by date times |
Relative | This is a custom date field, specified by time relative to now |
Last 15m | This is the last 15 minutes relative to now |
Last 30m | This is the last 30 minutes relative to now |
Last 1h | This is the last hour relative to now |
Last 12h | This is the last 12 hours relative to now |
Today | This is Today within your current timezone |
Tomorrow | This is Tomorrow within your current timezone, does not include Today. |
Yesterday | This is Yesterday within your current timezone, does not include Today |
Last 48 hours | This is the last 48 hours relative to now |
This Week | This is the current week you are in, dependent on your first day of the week |
Next Week | This is the next week you will be in, dependent on your first day of the week |
One Week | This is the week (7 days) before now |
Last Week | This is the last week you were in, does not include this week, dependent on your first day of the week |
Last Fortnight | This is the last fortnight you were in, does not include this fortnight, dependent on your first day of the week |
This Month | This is the current month you are in |
Next Month | This is the next month you will be in |
Last 30 Days | This is the last 30 days from now |
Last 45 Days | This is the last 45 days from now |
Last 90 Days | This is the last 90 days from now |
One Month | This is the one month (30 days) before now |
Last Month | This is the previous month you were in |
MTD | Month To Date, caution: does not work on all reports |
3 Months | This is the last 3 months starting from now |
13 Weeks | This is the last 13 weeks (91 days) starting from now, does not depend upon your first day of the week |
6 Months | This is the last 6 months starting from now |
12 Months | This is the last 12 months starting from now |
13 Months | This is the last 13 months starting from now |
18 Months | This is the last 18 months starting from now |
This Year | This is the current year you are in |
Next Year | This is the next year you will be in |
Last Year | This is the last year you were in, does not include this year. |
YTD | Year to Date, caution: does no work on all reports |
From Today | From 12 am today |
This Financial Year | This is the current financial year you are in |
Last Financial Year | This is the last financial year you were in |
Next Financial Year | This is the next financial year you will be in |
This Quarter | This is the current quarter you are in |
Last Quarter | This is the last quarter you were in |
Next Quarter | This is the next quarter you will be in |
All Time | All data |
Date Picker UI Controls
Display Config
Display Config allows you to modify the date picker alignment. The default alignment is left.
Change Type
Change Type allows you to change the display mode. The default display mode is Dropdown.
To learn more about the other date picker UI controls, go to UI Controls.