Date Picker enables you to filter based on the single or range of date selection.
The following steps explain to configure the table data to date picker:
Date Picker
from the toolbox at left into the design canvas and resize it to your required size.Data Source
button in the configuration panel.CREATE NEW
button to launch a new connection from the connection type panel.Microsoft Excel
Connection type is selected for demonstration) of the listed connection type button shown.NEW DATA SOURCE
configuration panel, fill the connection type and related details. Click the Connect
button.Save
button.Properties
button in the configuration panel, property pane opens. Now, switch to the ASSIGN DATA
tab.Dimensions
into the Columns
section.Switch to the Properties
pane and set the Selection Type
as Range
; Switch back to the Data
pane; Click the Settings
icon in the dropped date column and select Relative Dates...
in the drop-down menu.
In the launched Relative Date Options
window, configure the relative date and click Add. Repeat this process till the required set of relative dates are added.
You can see the added relative dates in the DatePicker as follows.
Switch to the Properties
pane and set the Selection Type
as Range, and then switch back to the Data pane; Click the Settings
icon in the dropped date column and select Relative Dates...
in the drop-down menu.
In the launched Relative Date Options
window, select the Custom
option from the drop-down list.
Choose the start and end dates you like to set as custom range, set a name for the custom range, and then click Add.
Repeat this process till the required set of custom relative dates are added.
You can see the added custom relative dates in the DatePicker as follows.
You can filter the data by using the Filter
option.
You can format the Date Picker for a better illustration of the view that you require through the settings available in the Properties
tab.
This allows you to set the title
for this date picker widget.
This allows you to set the subtitle
for this date picker widget.
This allows you to set the brief explanation about this date picker widget.
This allows you to toggle the selection type of Range.
Single – Single date can be bounded, if you disable the Range
selection option.
Range – A range of dates (two dates) can be bounded,if you enable the Range
selection option.
This allows you to enable the highlighting of available dates in the date picker.
This allows you to display only the limited dates (dates in the data source) in date picker, by default option will be enabled. If the option is enabled you can select the dates available in the data source.
If you disable the Limit Dates option, there is no limit for the date range.
If you enable the Range
option, the Fixed Calendar Selection
will be shown.
This allows you to select a date(start or end) without discarding your previous selection.
And you can only select a start date from the left calendar and the end date from the right calendar.
The show latest date property shows the latest date in the datasource when you open the datepicker popup.
This allows you to define this date picker widget as a master widget such that its filter action can be made to listen by other widgets in the dashboard.
This allows you to define this date picker widget to ignore responding to the filter actions applied on other widgets in dashboard.
Using this option, you can enable or disable the hierarchical top N filtering. While applying the Top N filter with multiple dimension columns, the data returned can be customized based on whether the filtering needs to be done as flat or based on the hierarchy of dimension columns added.
When the Enable Hierarchical Filtering
is enabled, the Top N will be applied for each individual column separately based on the number set for each column.
This allows you to handle the alignment of widget title to either left, center, or right.
This allows you to apply the text color
to the widget title.
On enabling Auto Font Size, the font size of the title will be adjusted automatically if the resolution of the screen varies.
Font Size
This allows you to apply the specified size of the font to the widget title if the Title Auto Font Size is disabled. Value can be between 10 and 44.
On enabling Auto Font Size , the font size of the subtitle will be adjusted automatically if the resolution of the screen varies.
Font Size
This allows you to apply the specified size of the font to the widget title if the Subtitle Auto Font Size is disabled. Value can be between 10 and 32.
This allows you to toggle the visibility of border
surrounding the widget.
This allows you to apply the specified radius
to the widget corners if the Show Border is enabled. Value can be between 0 and 10.
This allows you to set the background color to the date picker widget.
This property allows you to specify the transparency for the background color.
This allows you to toggle the visibility of the shadow
surrounding the widget.
This allows you to enable or disable the widget title
of the date picker widget.
This allows you to enable or disable comment
for the dashboard widget. For more details, refer to this link.