Rank

[varunreddy]

Hi,

I am trying to get the records where the rank is 1 and exclude all other filters.

Expression I am using is:

only({<[Observation/Report Date Summary] = {"=rank([Observation/Report Date Summary])=1"}>}[Observation/Report Date Summary])

Attached is the sample data set.

Can anyone guide me with this?

Thanks in advance!

Cheers,

Varun

[sunny_talwar]

Rank of Date? Is that a field or is that something you are calculating?

[varunreddy]

Process ID is one field and Date is one field. For some ID's I have one date and for others I have muktiple. Now I want the ID's with latest date if we have multiple dates, else we need the ID's.

So I am calculating rank(Date) and trying to pull with rank =1.

Did this explanation work?

[varunreddy]

This is what I obtain. Now I want the ID's where rank is 1. third column here is calculated.

i.e. Rank(Date)

[sunny_talwar · Accepted solution]

May be like this:

Aggr(If(Rank([Observation/Report Date Summary]) < 2, [Observation/Report Date Summary]), [Process ID], [Observation/Report Date Summary])

[varunreddy]

Thanks Sunny