AGGR () by row

[pete_bolin]

I need to calculate the difference between multiple dates by row, by ID. I used the AGGR() function to count the number dates within each ID's.  But now I need to calculate the difference, in days, between each date within each ID. Any help would be greatly appreciated! Cheers!

[ogautier62]

Hi,

take a look at function above()

could be something like : Date - above(Date)

with ID, Date as dimension

and if so count(ID) works, aggr not usefull

regards