When using multiple Keywords condition in a list filter or report Group by [field] returns incorrect counts - Support and Troubleshooting

When using multiple Keywords condition in a list filter or report Group by [field] returns incorrect counts Issue Overview Running a report with multiple keywords filter conditions with 'group by' condition returns incorrect group counts.

Subject When using multiple Keywords condition in a list filter or report, Group by [field] returns incorrect counts.

Example In OOB Instance (used Kingston patch 6),

Navigate to New Report

Table: Change Request

Type: List

Filter Conditions:

Keywords -> are -> David Loo

Run filter (observe 40 tickets in list, 36 are authorize)

Group by: State

Run filter

The group by number () indicates 30 in authorize.

Additional Information The issue encountered is a known error, previously documented in PRB583460 - When running a "Keywords" filter containing multiple words with a "Group by" in the report or query produces incorrect group record counts.

if you are able to filter on exactly one Keyword, such as "Loo", you should be able to use the "Group by" and the record counts displayed for each group will be correct.