Skip to main content
tony_tao
Contributor ⭐️⭐️⭐️⭐️⭐️
August 5, 2020
Solved

Multi Select in Report

  • August 5, 2020
  • 3 replies
  • 363 views

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

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
Expert ⭐️
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

Jean
cmultanen
Helper ⭐️
October 29, 2020

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