Home > User Voice > Changes to grouping/filtering multi value picker fields

Changes to grouping/filtering multi value picker fields UNDER REVIEW
7

MVP

Hi everyone,

maybe I have a wrong idea how a multi value picker field is used in filters/groups in reports.

Current situation:
The picker field will store the selected values in the order they have been chosen.
If you use this field as a group, every unique "string" will be used as a group.
Example:
Workflow instance 1: IT: Research & Development
Workflow instance 2: IT: Research & Development;Quality Management
Workflow instance 3: IT: Research & Development;Quality Management
Workflow instance 4: IT: Quality Management;Research & Development;
This will result in three groups, because the "strings" are different.
IT: Research & Development (1)
Research & Development;Quality Management (2)
Quality Management;Research & Development (1)

This is a problem, from my perspective.
As a user I don't care if the values have been selected in a specific order. So these groups should be reduced at least to these:
IT: Research & Development (1)
IT: Research & Development;Quality Management (3)

But in the end I would be even more interested in displaying groups for each individual selected option and display all instances which uses the single values:
IT: Research & Development (4)
Quality Management (3)

The same should apply to filters.

At least this is my opinion, how a multi value picker should be filterable/groupable.


Best regards,
Daniel

Verified in BPS 2022

Nobody has replied in this thread yet.