how to make min fucntion to work

[kunkumnaveen]

Hello  suppose if i got data like this

date    idnum

3 Jan      5

20 Jan    15

1 Feb      6

26 Feb     20    

expression: min(only({<idnum={20}>}Timestamp(date)),only({<LUid_measure={6}>}Timestamp(date)))

output i am expecting is :     1 Feb (with timestamp),but it throwing me error

Error i am getting is

Nested aggregation not allowed 

any help from you guys ....

thanks

naveen

[tresesco · Accepted solution]

Try RangeMin() instead, like:

Rangemin(only({<idnum={20}>}Timestamp(date)),only({<LUid_measure={6}>}Timestamp(date)))

[Anonymous]

Hi,

timestamp(min(aggr(only({<idnum={'20'}+{'6'}>} Timestamp(date)), idnum)))

This function will return the timestamp of idnum 6.

See the attached.

HIH

Elena