Configure the grouping of category fields

Introduction

Most Widgets have configuration fields that are used to generate separate shapes. These fields are used to group numerical fields together and generate a single shape for each context combination.

Examples :

• Chart : the chart column category (x position) of each point ; the creation of each trend series
• TreeMap : the creation of each rectangle
• …
  

Grouping function

There is no particular grouping function.
Only “Value of” is available.

It creates a group for each distinct value of the selected field.

For string, number and boolean fields

There is no particular configuration for the following types of fields :

• string
• number
• boolean
  

When they are added to a category configuration, they group the query without any formatting : each separate value creates a separate group.

*Note : Aggregated Expressions cannot be used as category fields because they only generate a single value, which is not desirable.

For date fields

Date fields can be formatted to create different groups :

• Year (default when adding a field)
• Quarter
• Quarter Year
• Month
• Month Year
• Week
• Day Of Week
• Day Of Year
• Day
• Hours
• Minutes
• Seconds
• Date
• Date Time : the full datetime detail (no formatting happens, each different value is a different category)
• Time