Search results

List Box

List Box enables you to filter based on single or multiple items selection in a list. To configure a list box, a minimum requirement of 1 column is needed.

List Box

How to configure the table data to list box?

The following procedure illustrates data configuration of List Box.

  1. Drag and drop List Box control icon from the tool box into design panel. You can find control in tool box by search.

List Box

  1. Click Data Source button in configuration panel.

Data button

  1. Click CREATE NEW button to launch a New Connection from connection type panel.

Data source button

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

Data source list

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

Connect button

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

Virtual table

  1. Click Properties button in Configuration panel, property pane opens. Now, Switch to ASSIGN DATA tab.

Designer properties

Data tab

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

Assign data

  1. Drag and drop a column from Measures or Dimensions to Columns section.

Configure Widget

Define the Sort of the dropped column through the Sort option in the Settings drop down menu. For more details refer Sort

Sorting

You can use the filters by selecting the Filter(s) option. For more details, refer filter.

Filtering

You can clear the filters by selecting the Show All Records option.

How to configure relative dates to list box?

Click the Settings icon in the dropped date value and select Relative Dates in the drop-down menu.

showing relative dates 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.

relative date options window

relative dates added in window

You can see the added relative dates in the list box as follows,

showing relative date options in listbox

Note: If Multi selection is enabled, then the applied relative dates will be removed.

How to configure custom relative dates to the list box?

Click the Settings icon in the dropped date value and select Relative Dates in the drop-down menu.

showing relative dates menu

In the launched Relative Date Options window, select the Custom option from the drop-down list.

selecting custom option in relative dates window

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.

setting range for custom option

custom date option is added

You can see the added custom relative dates in the list box as follows.

custom date option is displayed in list box

Note: If Multi selection is enabled, then the applied relative dates will be removed.

How to format list box?

You can format the List box for a better illustration of the view that you require, through the settings available in the Properties tab. This pane can be opened from the design view by clicking the Settings icon at the top right corner of the widget.

General Settings

General Settings

Name

This allows you to set the title for the list box widget.

General Settings

Subtitle

This allows you to set the subtitle for the list box widget.

General Settings

Description

This allows you to set the brief explanation about the list box widget.

General Settings

Basic Settings

Basic Settings

Enable Multi-select

Enable Multi-Select allows you to select one or more items in the dropdown list.

Single Selection

Single Selection

Multiple Selection

You can select the multiple items in the list box.

Multiple Selection

Filter

Filter

Act as Master Widget

This allows you to define this list box 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 list box widget to ignore responding to the filter actions applied on other widgets in the dashboard.

Enable hierarchical filtering

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

When the 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 the text color to the widget title.

Title Auto Font Size

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.

Subtitle Auto Font Size

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.

Show Border

This allows you to toggle the visibility of the border surrounding the widget.

Corner Radius

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.

Background Color

This allows you to set the background color to the list box widget.

Transparency

This property allows you to specify the transparency for the background color.

Show Shadow

This allows you to toggle the visibility of the shadow surrounding the widget.

Container actions

Container Actions

Show Header

This allows you to enable or disable the widget title of the list box widget.

Enable Comments

This allows you to enable or disable comment for the dashboard widget. For more details, refer to this link.