In Reporting, why are some columns not available for Group By?

[Jerry17]

In Reporting, why are some columns not available for Group By?  Are certain types of fields excluded from the Group By?

[Allen Andreas · Accepted solution]

Hi,

Certain fields aren't available for group by: normally date/time, list, etc.

If there's a particular field you'd like to try and group by...you can attempt to add this attribute to it:

can_group=true

To do this, you'd need to access the dictionary of the record and then set the view to advanced (in the related links, bottom left corner click "advanced") and then in the attributes box, place the can_group=true there.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Allen Andreas]

Hi,

I just wanted to check in on this. If my reply helped guide you correctly, please mark it as Helpful & Correct.

Thank you!