Group By Aggregate give me Max(column) where column is text...?

On a number field, I can do a group by and get the Max...

On a text column however, there is no option for Max? 

How can we do aggregates properly? There's no average, count distinct, std dev, etc... 

There is only count... :(

Hi PJ,

It seems that indeed Min and Max are not supported for Text Attributes. It would make sense to have this supported I guess, so I'd advise you to create an Idea for it.


# just create a new attribute on that aggregate, and use formula that results in number expression, for example:



@PJ: saw the Idea, so I thought I'd link it. It's here.

@Box: that wouldn't help much if you want a Max() on a Text Attribute!