Group By number field in Reporting on MDA Objects.

  • 7
  • Idea
  • Updated 1 year ago
  • Under Consideration
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.
Photo of Ankur Bhat

Ankur Bhat, Employee

  • 1,136 Points 1k badge 2x thumb

Posted 1 year ago

  • 7
Photo of nstuyvesant


  • 612 Points 500 badge 2x thumb
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?
Photo of Venkateswara Reddy Kasireddy

Venkateswara Reddy Kasireddy, Product Manager

  • 2,444 Points 2k badge 2x thumb
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.
Photo of Kevin Ly

Kevin Ly, Employee

  • 3,270 Points 3k badge 2x thumb
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
Photo of Melissa Terrell

Melissa Terrell

  • 600 Points 500 badge 2x thumb
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.  
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 12,426 Points 10k badge 2x thumb
Changing this to Idea post for future reference 
Photo of Brittany

Brittany, Champion

  • 3,060 Points 3k badge 2x thumb