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