Tables are a major part of Ignition Reporting. They are composable and highly flexible, giving Reporting users the ability to flexibly layout and organize tabular data.
Sorting orders your data by a key or list of keys. There are three types of Sorting in Tables.
- Default - data is sorted based on the order in which it is retrieved.
- Basic - takes a list of keys and sorts by the first one. If the sort results in a tie, the tie will be resolved by the next key in the list, and so on.
- TopN - uses a single key path, with a Count value that allows a limit to the number of rows that are processed.
Basic and TopN sorts can be configured for either ascending ( ) or descending ( ) sorts. They can also utilize aggregate (calculation) keys.
The TopN option Include Otherswill include all values outside of the specified Count range by compressing them into a single row.
Basic Sort Example
We will look at the same table using different sorts. Both have the same exact layout (we made the first, and simply copy/paste to replicate). The first uses Default sort, the second will use a Basic Sort as configured in the image.
To alternate to descending, we could click theicon and it would toggle to a descending sort.
These are our resulting tables, showing the left table sorted by its primary key (OrderID) and the right sorted by Ascending Subtotal.
Filtering gives the option of processing data based on an expression. The Filtering property can be found in the Property Inspector under the Properties tab.
If the expression resolves false, the row will be skipped. Note: you do not need @ symbols to reference keys.
Filtered TopN Sort Example
This example is sorted descending by downtime and filtered by downtime greater than 20 minutes.