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.

Widget Value aggregation

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.

For date fields

Date fields can be formatted to create different groups :

Widget date formatting
  • 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
Last modified: Sep 13, 2021


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment