Group By number field in Reporting on MDA Objects.

  • 6
  • Idea
  • Updated 11 months 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,006 Points 1k badge 2x thumb

Posted 11 months ago

  • 6
Photo of nstuyvesant

nstuyvesant

  • 582 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, Official Rep

  • 2,220 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,104 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
(Edited)
Photo of Melissa Terrell

Melissa Terrell

  • 590 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

  • 9,126 Points 5k badge 2x thumb
Changing this to Idea post for future reference 
Photo of Brittany

Brittany, Champion

  • 3,022 Points 3k badge 2x thumb