Report Data Configuration
In addition to configuring rows, you can also configure how you want your data to appear in a report using the Sort and Filter functions in the Table component.
Sorting orders your data by a single data key or list of data 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 data keys and sorts by the first one. If the sort results in a tie, the tie will be resolved by the next data 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 sort option, Include Others if selected, will include all values outside of the specified Count range by compressing them into a single row.
The CSV dataset containing all the data and the table used for the following Sort and Filter examples are shown below.
Filtering gives the option of processing data based on an expression. The Filter Key property can be found in the Property Inspector under the Properties tab.
This example is sorted in ascending order using the Subtotal data key, and filtered for any 'Subtotal>1000.' To alternate to descending order, click the Ascending icon ( ) to toggle to a descending sort.