Filter, sort and grouping

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)

filter

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.

sorting

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.

Grouping

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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