Why is Group By sometimes disabled for certain fields?

Question

The Group By option is sometimes disabled for some fields in Dashboards, as well as in other parts of the application.

Answer

Grouping in grids is a feature of the UI framework (SGWT) and for performance reasons there is a limit on the number of rows in the grid. If there are more rows, the feature is not available.

The limit is controlled by the option Max Grid Group By in Configuration. The default value is 1000; performance degrades very quickly if you try to raise it.

It is recommended to add one or more inputs in your Dashboard where the user could pick the Group By dimensions, so your logic could do a group by query.

Found an issue in documentation? Write to us.