Skip to main content
Solved

Multi Select in Report

  • August 5, 2020
  • 3 replies
  • 344 views

tony_tao
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️⭐️⭐️

We just created some milti select picklist fields in the contact object in Salesforce. When creating a report builder and trying to add the fields into a Gainisght report, I notice that the fields are not available. Is this expected that Gainsight does not support multi select picklist values in Report Builder?

 

Is there a workaround???

Best answer by jean.nairon

@tony_tao - you should be able to add them in the Show fields section but you will not be able to add them in the By section. The By section has some limitations. 
 

You cannot add the following data types to the By section:

  • Rich Text Area
  • Multipicklist
  • Measures (Number, Currency, and Percentage, etc.)
  • Address
  • URL

 

For more information, please check this article: 

https://support.gainsight.com/Gainsight_NXT/Reports_and_Dashboards/Admin_Guides/How_to_Build_Basic_Reports#By

3 replies

Forum|alt.badge.img+1
  • Gainsight Employee ⭐️
  • August 5, 2020

We can’t add multi picklist type fields in ‘By’ section of reports. It works for Show fields, though. Are you trying to add it in By section?


jean.nairon
Forum|alt.badge.img+4
  • Expert ⭐️
  • Answer
  • August 5, 2020

@tony_tao - you should be able to add them in the Show fields section but you will not be able to add them in the By section. The By section has some limitations. 
 

You cannot add the following data types to the By section:

  • Rich Text Area
  • Multipicklist
  • Measures (Number, Currency, and Percentage, etc.)
  • Address
  • URL

 

For more information, please check this article: 

https://support.gainsight.com/Gainsight_NXT/Reports_and_Dashboards/Admin_Guides/How_to_Build_Basic_Reports#By


cmultanen
Forum|alt.badge.img+1
  • Helper ⭐️
  • October 29, 2020

Will this limitation be addressed with the Horizon Experience redesign of Report Builder?