We have 6 multi-select picklist fields we are currently using to track feature limitations that are blocking our customers from moving to the next generation of our product. These fields represent 6 main product lines and have anywhere from 3-16 feature options each. I have a few requests from our team to report on these items in the following formats...
1. A pie or bar chart showing the total number of accounts that have each feature selected
2. Report of the top 5 features across all 6 product lines
The issues I'm running into are 1. These are 6 different fields and 2. Gainsight doesn't allow us to group by or aggregate multi-select fields. The only reporting option I've been able to come up with is just adding all 6 fields in the 'show me' section of a report along with Account Name and enabling row grouping by account. The only way I see today to show a count by feature is to filter by an individual feature and create a widget for each one....which isn't really an option because there are too many to even put them all on one dashboard. Other thoughts/ideas to better report on these fields? I'm open to creating new fields/formats if needed, I just don't want to go to all that work for an experiment that may or may not give me what I need. Also, any info from Gainsight as to WHY we don't have more options to maniputale and report on multi-select fields?
Page 3 / 3
This is not a step forward.
You now group by a concatenated grouping of options.
Released→Discovery
We are currently facing this issue as well. I have already had a member of leadership tell me the reporting for this particularly activity type is worthless because of the lack of visibility. Just adding our needs to the growing pile.
I’m a bit baffled about what was released here, which doesn’t solve the issue that everyone has been reporting and asking for a solution to.
Reporting on multi-select fields remains useless in it’s current state. Tomas has perfectly summed up what needs to happen to make this functionality useful. We don’t even bother trying to report on multi-select fields because the concatted results are so useless and don’t answer the questions we’re asking, and this is a massive data miss for us.
Would love to see this prioritised for a proper fix!
Hello,
Its on our short term roadmap and we are hoping to release it in Q4. We understand the concern,but unfortunately, I can’t provide any more further details than this.
Thanks
Prateek
Hi,
Is there any updates on this?
Thank you!
I am following up on this thread seeking an update. We have a use case where a CSM is tracking Risks and some Risks may apply to multiple products and we want to track that, however, when seeking to report out on which products have the greatest number of risks, I am not able to easily see that and am just seeing all of the permutations of products selected by a CSM. It would be great if each item could be broken out and counted.
Hi team,
Any update to this? This is an highly upvoted need and the release from more than a year ago didn’t help one bit.
And from my point of view this isn’t even just an admin quality-of-life improvement, since the workarounds available actually impact the end-user experience.
Hi
We can’t just keep avoiding multi-picklists because of this.
Alizée
We are trying hard to see if we can pick this up and release in Q3 , but unfortunately, I am not in a position to provide a confirmed release timeline for this ask. (We know what’s the missing part that we have to build based on the feedback shared on this post)
I hope it gets picked up too, as it’s the only way to report on multi picklists, which other tools do nateively, and to use some of the report types you offer (for example, the gauge reports). I am not sure why it was first enabled as a concatenation of all options a record has selected.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.