Tables - Sorting and Filtering

Sorting orders your data by a key or list of keys. Filtering excludes data based on some condition. Both are done in the table inspector.

Sorting

There are two similar methods of sorting. They can be ascending () or descending () and can use aggregate keys.

Sort takes a list of keys and sorts by the first one. In the event of a tie it goes down the list.

TopN uses a single key path. The Count option allows a limit to the number of rows processed.

Filtering

Filtering gives the option of processing data based on an expression. If the expression resolves false, the row will be skipped. Note: you do not need @ symbols to reference keys.

Example

This example is sorted descending by downtime and filtered by downtime greater than 20 minutes.

Previous (Table rows)   Next (Rows Versioning)