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

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.

Hi PJM,

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


If(NAME="READ_ONLY",0,1)

regards,

@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!