Skip to main content
ankur_bhat
ankur_bhat
Helper ⭐️
July 14, 2017

Group By number field in Reporting on MDA Objects.

  • July 14, 2017
  • 6 replies
  • 46 views
As of now, we don't support number fields in "Group By" section in reporting. Would it be possible to have this feature implemented in Reporting for MDA Objects?

P.S. - It is not supported in SFDC.

      6 replies

      nstuyvesant
      nstuyvesant
      Contributor ⭐️⭐️
      July 14, 2017
      As the MDA Objects sit on Amazon Redshift, it would be great if Group By on Number fields would be permitted. The Salesforce limitation does not apply to Redshift. In the Report Builder UI, perhaps check to see whether the object for reporting is MDA or SFDC. If the former, permit group by else not?
      venky_reddy_k
      venky_reddy_k
      Helper ⭐️
      July 17, 2017
      This needs to be thought through to cover all use cases of filter, calculated measures and Group by when we allow a number to be grouped by. We may take it up sometime in future based on how volume of ask.
      sai_ram
      sai_ram
      Expert ⭐️⭐️
      July 17, 2017
      Changing this to Idea post for future reference 
      kevin_ly
      kevin_ly
      Helper ⭐️
      July 17, 2017
      To start, allow cumulative values report option on group by number field would be nice as well. Provided the X-axis is sorted ascending or descending.

      - I chatted with a customer and I thought it was a good idea as well, posting in here just incase
      melissa_terrell
      melissa_terrell
      Helper ⭐️
      July 17, 2017
      Yes!  would love the ability to group by a number field and then create a cumulative line graph based on the sorting of that number field.  For example, if you could group by 0, 1, 2, 3, 4 and the show the cumulation of the count of values associated with each number value based on the desired sorting.  
      brittany
      brittany
      Contributor ⭐️⭐️⭐️⭐️⭐️
      August 1, 2017
      I think this could merge with my post:
      https://community.gainsight.com/gainsight/topics/be-able-to-report-on-mda-data-with-number-field-typ...
      Terms & ConditionsAccessibility statement