Reporting on Multi-Select Picklist Fields

The feature has gone into dev, hence changing the status to in Development. To reiterate, we are enabling users to do group by on multi-select picklist data types/fields.  

Hello All,

This work item has gone into production. Users can now perform Group by functionality on multi select pick-list fields.

Feel free to  share your feedback/ suggestions(if any)

Regards

Prateek

Hi @Prateek Parashar 

Am I misunderstanding this, or was the only thing that changed is there is now the ability to add a multi-select type field into the “Group By” section, but it simply groups by the concatenated value of all possible options rather than the individual values themselves?

@Tomas Trijonis  Yes , that’s what the release included as mentioned in my previous comments .Is there anything specific use case that you are looking for?

I cannot speak for everyone as I am subject to my own biases, but my case matches the interpretation I got from comments such as ones by Katie in the original post, Kraig, John, Jessica, Thomas and others.

It being the fact that grouping by a multiselect needs to be able to identify trends which options are selected most frequently.

In my own case (heavily simplified), we have a multiselect of tags (types) for a support ticket. A ticket may be a simple Consultancy, it may be a simple Troubleshoot, or it may be tagged as both. We care little about the exact number that Consultancy and Troubleshoot appeared together at the same time. We care a lot how many times Consultancy is a selected type, and how many times Troubleshoot is a selected, separated out.

Let me simplify further with an example, imagine you are reporting on the most popular products sold by a fast food joint. People may order combos of burger, fries, ice cream, cola and salad. While there may be cases where you may want to see how many times a burger+fries combo was sold specifically, you would most definitely want to know how many of each individual product was sold in total and draw a pie chart (for example). If you use existing multiselect reporting features in Gainsight these 5 features can return up to a 5 factorial number of combinations in a piechart, that is op to 120 slices with only 5 of these options. Good luck interpreting this chart. What you would like to see instead is 5 slices with each of the products representing an individual pie slice.

Actually it wouldn’t be 120 but less due to unimportance of order, before any statisticians crucify me here, but it would still be too many to work with is my point okay 😂

I agree with this. We use a multi-select dropdown for multiple fields based on the status, which is a manual input we have to get directly from the customer. The concat format is not pleasing to the eye when trying to look at these on reports. CSMs and their managers need something that shows which products are selected for each category in an easy to read format, such as the pie chart Tomas mentioned. 

@Tomas Trijonis . Thanks for the reply. The scenario you are looking for is not supported now. 

I have kept this n the backlog, and we will try to find a window to release it, but I am not in a position to give any deadline by when we would be able to do that.