Filter, sort and grouping

Some visualizations has the ability to filter, sort and group items.


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 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.



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.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s