Skip to main content
tony_tao
Contributor ⭐️⭐️⭐️⭐️⭐️
Aug 5, 2020 6:20 AM UTC
Solved

Multi Select in Report

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

jean.nairon
Expert ⭐️
Aug 5, 2020 4:34 PM UTC

@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

Jean

3 replies

Gainsight Employee ⭐️
Aug 5, 2020 9:41 AM UTC

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?

Translate
jean.nairon
Expert ⭐️
Aug 5, 2020 4:34 PM UTC

@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

Translate
Jean
cmultanen
Helper ⭐️
Oct 29, 2020 8:30 PM UTC

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

Translate