Date Picker enables you to filter based on the single or range of date selection.
Drag and drop the Date Picker
from toolbox at left into design canvas and resize it to your required size.
Click Data Source
button in configuration panel.
Click CREATE NEW
button to launch a new connection from connection type panel.
In the connection type panel, click any one (Here Microsoft SQL
Connection type is selected for demonstration) of the listed connection type button shown.
In the NEW DATA SOURCE
configuration panel, fill the connection type and related details. Click Connect
button
Drag your preferred table or view from the left pane from data design view, click Save
button.
Click Properties
button in configuration panel, property pane opens. Now, Switch to ASSIGN DATA
tab.
The data tab will be opened with available measures and dimensions from the connected data source
Drag and drop a date field from Dimensions
into 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 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 format the Date Picker for better illustration of the view that you require, through the settings available in Properties
tab.
General Settings
Name
This allows you to set title for this Date Picker widget.
Basic Settings
Range
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.
Highlight Available Dates
This allows you to enable the highlighting of available dates in date picker.
Limit Dates
This allows you to display only the limited dates (dates in the datasource) in date picker, by default option will be enabled. If 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.
Filter
Act as Master Widget
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.
Ignore Filter Actions
This allows you to define this date picker widget to ignore responding to the filter actions applied on other widgets in dashboard.
Container Settings
Title Alignment
This allows you to handle the alignment of widget title to either left, center or right.
Title Color
This allows you to apply text color to the widget title.
Show Border
This allows you to toggle the visibility of border surrounding the widget.
Corner Radius
This allows you to apply the specified radius to the widget corners. Value can be between 0 and 10.
Enable Comments
This allows you to enable/disable comment for dashboard widget. For more details refer here