Skip to main content
Discovery

Reporting on Multi-Select Picklist Fields

Related products:CS Reports

katie_b
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?

56 replies

sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • 3727 replies
  • August 1, 2019
Hi Katie, Thanks for bringing this up! we have added this to our road-map, will update here once we consider this feature for release.

 

Happy posting!


kraig
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 54 replies
  • September 28, 2019
I am really happy to have found this post. We recently transitioned our Enhancements Request process into a series of multi-select picklist, before realizing how limited Gainsight's reporting capabilities are in this area. Now we feel stuck.

Our goal is to create visual reports (pie charts, stacked column, heat maps, etc.) from these fields, to help us identify themes. Thank you for having this on the roadmap already, but feel free to reach out if you would like to understand our use case more thoroughly.


lyne_therien
Forum|alt.badge.img+1
  • Helper ⭐️
  • 86 replies
  • October 1, 2019
That would really help us with reporting! There should be a way....


lori_austin
Forum|alt.badge.img
  • Contributor ⭐️
  • 2 replies
  • October 1, 2019
Adding multi-select is great...just need the reporting to follow...


sacha
Forum|alt.badge.img+2
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 57 replies
  • February 5, 2020

Hi @sai_ram is there any update on adding this feature to the product? Thank you very much,


sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • 3727 replies
  • February 25, 2020

@sacha We are exploring some options here, this might be a medium-term item.

 

If the timeline does not match, you can maybe check if pivoting in rules can solve your use-case. 


bradley
Forum|alt.badge.img+7
  • Expert ⭐️
  • 1127 replies
  • December 30, 2020
sai_ram wrote:

@sacha We are exploring some options here, this might be a medium-term item.

 

If the timeline does not match, you can maybe check if pivoting in rules can solve your use-case. 

@sai_ram  Pivot Rules also do not support multiselect dropdown fields as a pivot or group by field


bradley
Forum|alt.badge.img+7
  • Expert ⭐️
  • 1127 replies
  • March 5, 2021

@sai_ram any update on this? Multiselect dropdown fields are great for capturing certain types of data but are the bane of my existence for reporting.


jlicciardello
Forum|alt.badge.img+1
  • Contributor ⭐️⭐️⭐️⭐️
  • 39 replies
  • June 16, 2021

Another vote for this issue. Would love to see some options for Multi-select in reporting. A pie chart with any mult-selects appearing in “Multiple” slice would work! 


jrzlawrence
Forum|alt.badge.img
  • Contributor ⭐️⭐️
  • 4 replies
  • May 19, 2022

Also upvoting this feature request! We have a similar use-case as the original poster. We want to know what issues are outstanding when an account (company) moves from onboarding to CS, so we have a multi-select of a handful of options for the CSM to select what was not completed or was an issue during onboarding. We don’t have a good way of aggregating the results, since we used a multi-select. How do we identify trends or problem areas easily without being able to count how many times each option was selected across hundreds of customers?


anirbandutta
Forum|alt.badge.img+2
  • Expert ⭐️
  • 1804 replies
  • May 19, 2022

Blast from the past this thread. @rakesh if you could pl take a look during your day.


Forum|alt.badge.img+2
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 88 replies
  • July 19, 2022

I’m sure if the solution is implemented it would be applied to similar report types equally, but we would like to leverage the Packed Bubble report type for this. Crossing our fingers for something soon!


iainr
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️
  • 24 replies
  • July 28, 2022

Adding my voice to the demand for this. Surprised it’s been open so long for something that seems a fairly fundamental reporting capability tbh!


Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️
  • 15 replies
  • September 7, 2022

Adding our support for this request as well! This is currently impacting our ability to report on key information for our customers when capturing risks.


sarahmiracle
Forum|alt.badge.img+10
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 354 replies
  • September 7, 2022

I’m about to launch a multi-select picklist for products purchased in our instance with the goal of improving reporting and now I’m scared about the implications this will have on reporting 😓


TMaier
Forum|alt.badge.img+5
  • Helper ⭐️
  • 175 replies
  • September 7, 2022

The gist is that without applying some kind of workaround, if a customer purchases Product A and Product B you will have a single column for “A;B” with a quantity of 1 vs individual columns for Product A and Product B with 1 each.

 

If two more customers come in and one purchases Product A only, and the other purchases Product B only, you will now have 3 columns for “A” , “B”, and “A;B”. It’s no fun!


lyne_therien
Forum|alt.badge.img+1
  • Helper ⭐️
  • 86 replies
  • September 7, 2022

@sai_ram Do you have any update on this? 2 years ago we learned that this was on the roadmap. As it fallen off by chance? Thanks!


bradley
Forum|alt.badge.img+7
  • Expert ⭐️
  • 1127 replies
  • September 7, 2022
lyne_therien wrote:

@sai_ram Do you have any update on this? 2 years ago we learned that this was on the roadmap. As it fallen off by chance? Thanks!

He’s not at Gainsight anymore :) Paging @anirbandutta to the rescue!


anirbandutta
Forum|alt.badge.img+2
  • Expert ⭐️
  • 1804 replies
  • September 8, 2022

Thanks Bradley. Let me try to get a sense of where we are at with this and share.


Azad
Forum|alt.badge.img
  • Gainsight Employee ⭐️
  • 95 replies
  • September 9, 2022

Hey Everyone, 

First of all thank you soo much for the insights here on the need to have picklist aggregatable, I have started discussions with the engg team to look into possibilities of enabling this, since as of today we do not even allow to group by existing combination groups. 

I will have more updates for everyone towards the end of the month. 


  • Contributor ⭐️⭐️⭐️⭐️
  • 49 replies
  • December 7, 2022

Hello @Azad - Is there any update on this? What is the progress of this change request?


james_dahlgard
Forum|alt.badge.img+2
  • Contributor ⭐️⭐️
  • 3 replies
  • February 28, 2023

This is a huge blocker for reporting with us as well. 


Tomas Trijonis
  • Contributor ⭐️⭐️⭐️⭐️
  • 44 replies
  • May 8, 2023

No update on this still? @Azad @anirbandutta It’s an important feature for us too.


mbond
Forum|alt.badge.img+2
  • Contributor ⭐️⭐️⭐️
  • 21 replies
  • May 11, 2023

Would also love to see it live


alizee
Forum|alt.badge.img+11
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 652 replies
  • May 11, 2023

EVERYTHING MULTI-SELECT IS DIFFICULT… PLEASE FIX THEM. #adminqol


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings