To work with the tool in Foresight Analytics Platform 10, use the new interface.

Sorting and Filtering

Use sorting and filtering if required.

Sorting

Table data can be sorted by columns and/or by rows.

Sorting options for the selected column or row are selected using sorting icons in row and column headers. Icons are displayed when sorting is enabled. To enable sorting, click the Sorting button on the Table ribbon tab.

On consequent pressing of any of the icons its view is changed, therefore the sorting type is changed:

Filtering

Data filtering enables the user to display only the data that satisfies the specified conditions.

Data filtering in report columns is executed using the Filtering Settings button in column headers. To display the Filtering Settings buttons, click the Filtering button on the Table ribbon tab.

As a result of filtering application, all elements selected in the list formed from all values of filtered strings will be displayed in the table. For columns, for which the filtering is set up, the button will look like: .

The following commands are available in the menu of the Filtering Settings button:

The following parameters can be set in this dialog box:

NOTE. This filter will not be available if there are no numeric values in filtered strings.

The following parameters can be set in this dialog box:

To disable filtering for all columns at the same time, release the Filtering button on the Table ribbon tab.

It is available to set up and save filtering in the data entry form table area using custom settings.

When sorting and filtering are finished, follow the step if required:

See also:

Getting Started with the Interactive Data Entry Forms in the Web Application | Working with Ready Data Entry Form