Some visualizations has the ability to filter, sort and group items.
Filtering
When filtering is applied, only items that satisfy the filtering condition will be visible on the screen.
Filtering consist of the four parts
- The filtering column – the column to be filtered
- Filtering data type, these data types are supported: number/text/datetime/dateonly/boolean/currency
- Filter operator, these operators are supported
- = (equal)
- != (not equal)
- > (greater than)
- < (less than)
- >= (greater or equal)
- <= (less or equal)
- Begins with (text only)
- Ends with (text only)
- Contains (text only)
- Between (text, number, currency, datetime, dateonly)
Sorting
Sorting supports number, text and datetime, in both ascending (small to large) and descending (large to small) order.
Only one sort is allowed. When grouping is applied, sorting will happen within the group.
Grouping
Data can be visually grouped, each unique value in the grouping column will create a group. In the following example, there are three unique values in the column “Grant group”, low/medium/high. So, three grouping boxes are created.