Aggr function?

[antonaks]

Hello everybody.

I nave a issue with aggr function. Example is attached.

I need to show sum of value data in the table for latest and earliest Timestamp by Clients.

But when I use set analysis I have only one value (max or min from all data set).

I'm Asking for help. Thank you.

[sunny_talwar · Accepted solution]

Try these expressions

Timestamp(Min([Time of SnapShoot]))

Timestamp(Max([Time of SnapShoot]))

FirstSortedValue(Aggr(Sum(Value), [Time of SnapShoot], Name), Aggr([Time of SnapShoot], [Time of SnapShoot], Name))

FirstSortedValue(Aggr(Sum(Value), [Time of SnapShoot], Name), -Aggr([Time of SnapShoot], [Time of SnapShoot], Name))

[antonaks]

It works! Thank you!