How to get latest record from the table?

[ashishbhuyekar]

Hi All,

I have data set like below,

Route	ID	Status
6	1	Available
12	1	New Requiremnt
6	2	Available
12	2	New Requiremnt
6	3	Available
12	3	Change Required
18	3	New Requiremnt

Can you please help me with the expression where in chart it will show the latest record irrespective of selection on Route.

This is default view -

Route	ID	Status
12	28428	New Requiremnt
12	240077	New Requiremnt
18	240127	New Requiremnt

Also if i select route = 6 then it should allow to show below output. If i choose 12 only Route = 12 records should be displayed.

Route	ID	Status
6	28428	Available
6	240077	Available
6	240127	Available

Can any one help me in this regard?

[sunny_talwar · Accepted solution]

May be try this

Dimension

ID

Expressions

Max(Route)

FirstSortedValue(Status, -Route)