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!