Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody.
I have to calculate the most recent date ( i think it´s something like this MAX(DATE))
and i have to group this by a field, for example WEBNUMBER
but i see that the group by doesn´t exists in the expressions part. Do i have to use aggr function?
thanks.
Hi Jeremias,
It depends on what you need the date for - if you simply need the latest date for each WEBNUMBER then a straight table with WEBNUMBER as your dimension and Max(Date) as your expression should give you that.
Alternatively yes, if you want to group by WEBNUMBER then the Aggr function is the correct one to use, but in what format would depend on what you were trying to aggregate them for!