Reports Group By List Field

[ican]

Use Case:

I have a bar graph report in the dashboard and I am able to Group by a List field but I want to separate multi values separated by comma.

Sample:

Name	Category
Test1	Category1
Test2	Category1, Category2

In the bar graph which grouped by Category, the Category1 should display 2 counts and Category2 should display 1.

But for now it is displaying Category1 = 1 count Category1, Category2 = 1 count.

How to do this?

Thanks.

[Dr Atul G- LNG]

This is expected behaviour, bcz system is not smart to use the delimited , and separate the records in 2 and then count., That is manual part you need to do.