Range Navigator

Range Navigator allows you to filter based on the date range dynamically set through navigation bars.

Range Navigator

How to configure flat table data to Range Navigator?

The following procedure illustrates data configuration of Range Navigator.

Drag and drop Range Navigator control icon from the Tool box into design panel. You can find control in Toolbox by search.

Drag and drop range navigator

Before Resizing

Before Resizing range navigator

After Resizing

After Resizing range navigator

After control added in design panel, click Assign Data button at Design Tools Pane to open the Data configuration pane.

Assign Data

Bind a Measure column to Value section and a Date type column to Argument section.

Measure column to Value

Date type column to Argument

You can use the aggregation function to change the values of the elements.

Aggregation function

You can select the type of Date and Time as required by clicking the Setting button.

Settings

You can use the Relative Date Filter option to filter the Range and Period.

Relative Date Filter

Range option

Period option

Select the Link to specific date option to select the specific date.

Link to specific date

You can use the Filter(s)… option to apply the filter condition for date.

Filters option to apply condition

Range Filter will be shown to set either the Range, Start Date or End Date and click Apply.

Ranges

Ranges

Start Date

Start Date

End Date

End Date

Here is an illustration,

Example given

How to configure SSAS data to Range Navigator?

Following steps illustrates configuration of SSAS data to Range Navigator.

Drag and drop the Range Navigator widget into canvas and resize into your required size.

Range Navigator in canvas

Before Resizing

Before Resizing

After Resizing

After Resizing

Select the dropped widget using mouse.

Select the dropped widget

Click the Assign Data button in the toolbar.

A Data pane will be opened with available Measures and Dimensions.

Assign Data

Drag and drop a column under Measures category into Value(s) section.

column in measure and value

Drag and drop a column under Dimensions category into Argument section.

column in Dimension and argument

Define relative date filter criteria through Relative Date Filter menu item in the Settings drop down menu.

Relative Date Filter

Range

Period

Select the Link to specific date option to select the specific date

Link to specific date

Define filter criteria through Filter(s)… menu item in the Settings drop down menu.

Filtering criteria

Select Filter(s)… to launch the Filters window.

set either the Range, Start Date or End Date and click Apply.

Ranges

Ranges

Start Date

Start Date

End Date

End Date

Here is an illustration,

Example given

How to Format Range Navigator widget?

You can format the Range Navigator for better illustration of the view that you require, through the settings available in Properties pane.

General Settings

General Settings

Header

This allows you to set title for this range navigator widget.

SubHeading

This allows you to set sub-title for this ComboBox widget.

Description

This allows you to set description for this range navigator widget, whose visibility will be denoted by i icon, hovering which will display this description in tooltip.

Basic Settings

Basic Settings

Series Type

You can change the series type to any chart type to render in range navigator.

Series Type

Filter settings

Filter settings

Act as Master Widget

This allows you to define this range navigator widget as a master widget such that its filter action can be made to listen by other widgets in the dashboard.

Ignore Filter Options

This allows you to define this range navigator widget to ignore responding to the filter actions applied on other widgets in dashboard.

Container Appearance

Container Appearance

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.