Implement "Group by View" for Asset Inventory

[opauloh]

Motivation

To provide users with a more intuitive way of exploring their asset inventory, a "Group by View" should be added to complement the DataGrid. This feature allows users to group assets by specific fields, enabling quick aggregation and categorization of data for better insights.

Definition of Done

• Add a toggle to switch between DataGrid and Group by View visualizations.
• Implement the Group by View using the @kbn/grouping package for consistency and reusability.
• Provide a dropdown menu to select grouping fields, including:
  • Asset type (asset.type)
  • Asset category (asset.category)
  • Risk (host.risk.calculated_level)
  • Criticality (asset.criticality)
  • Custom field: Allow users to input/select a custom field for grouping.
• Display the following information for each group row:
  • The grouped term value.
  • The count of assets in that group.
  • A button to expand the group and view the assets in a filtered DataGrid.
• Ensure group expansion dynamically displays assets in a DataGrid filtered by the selected grouping field.
• Pagination: Display 10 groups per page by default, with pagination controls to navigate between pages.
• Rows per page dropdown: Allow users to adjust the number of groups displayed per page (options: 10, 25, 50, 100).

Screenshot

Out of Scope

• Custom DataGrid visualization for individual groups.
• Sub-grouping functionality (to be covered in a separate ticket).

Requirements

• Use the @kbn/grouping package for unified grouping logic.
• Reference the [CloudSecurityGrouping](https://github.com/elastic/kibana/blob/main/x-pack/plugins/cloud_security_posture/public/components/cloud_security_grouping/cloud_security_grouping.tsx) implementation for guidance.
• Ensure the UI and interactions are consistent with existing Kibana design patterns.

Related tasks/epics

• https://github.com/elastic/security-team/issues/10345
• https://github.com/elastic/security-team/issues/11247
• Figma mocks

[elasticmachine]

Pinging @elastic/kibana-cloud-security-posture (Team:Cloud Security)