Search results

Range Navigator

Range navigator control provides an effective interface for selecting a smaller range from a large collection. It is commonly used to filter the date range for which the data is visualized.

Range Navigator

How to configure table data to range navigator?

To configure range navigator, a minimum requirement of value and column is needed.

The following procedure illustrates data configuration of Range Navigator.

Click Data Source button in configuration panel.

Data button

Click CREATE NEW button to launch a new connection from connection type panel.

Data source button

In the connection type panel, click any one (Here Microsoft SQL Connection type is selected for demonstration) of the listed connection type button shown.

Data source list

In the NEW DATA SOURCE configuration panel, fill the connection type and related details. Click Connect button

Connect button

Drag your preferred table or view from the left panel from data design view, click Save button.

Virtual table

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

Range Navigator

Click Properties button in configuration panel, property panel opens. Now, Switch to ASSIGN DATA tab.

Range Navigator properties button

Data tab

The data tab will be opened with available measures and dimensions from the connected data source

Range Navigator Assign data

Bind column through drag and drop element from Measures section to Value.

Range Navigator Value data

You can add more than one Measures into Value.

Click the Settings option to change required summary type from the available summary types shown in Settings.

Range Navigator Summary type

Drag and drop element from Dimensions or Measures field into Argument section.

Range Navigator Argument data

Range Navigator Argument data

Click the Settings option to change required date format. You can also set Relative Date Filter.

Settings icon is not applicable for Measures values.

Range Navigator date Format

Range Navigator Value section

Select Relative Date Filter in the drop-down menu and click Edit option to set relative date,

Range Navigator relative date

Following window opens,

Range Navigator relative date set

In that window, you can set Range and Period option. You can also set Specific date by enabling Link to specific date and click OK button.

Here is an illustration,

Range Navigator

How to format Range Navigator?

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

General Settings

Range Navigator Name

Name

This allows you to set title for this Range Navigator widget.

Color Settings

Range Navigator Color Settings

This allows you to customize Range chart series color.

Label Color

This allows you to customize the label color.

Range Navigator Label Color Settings

Range Navigator Label Color

Axis Type Settings

Range Navigator Axis Type Settings

You can change range chart type as Area or Line or Step Line by dropdown.

Range Navigator Chart Type Settings

Here is an illustration,

Range Navigator Line Type

Filter

Range Navigator Filter Setting

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 Actions

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

Hierarchical Filter

Through this option, you can enable/disable hierarchical top N filtering. While applying Top N filter with multiple dimension columns, the data returned can be customized based on whether the filtering need to be done as flat or based on the hierarchy of dimension columns added.

When Hierarchical Filter option is enabled, the Top N will be applied for each individual column separately based on the number set for each column.

Container Appearance

Container Appearance

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