Top | Previous | Next |
|
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. There are two similar methods of sorting. They can be ascending ( 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 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.
This example is sorted descending by downtime and filtered by downtime greater than 20 minutes.
Previous (Table rows) Next (Rows Versioning)
|