How to slice only unique values with latest dates

[Gerhard_Viljoen]

Hi There,

I am uploading employee contracts and have the date of each contract that was signed in a field. I want to do a slice where only the latest field of each unique employee is shown as each year their contracts are updated.
And then I only want to show the 10 employees whose contracts were signed the longest time ago. I want to show this in a graph or table view on a dashboard.

Can someone please help me to devise a plan for the slice that can give me this outcome?

Thank you!

[Suvrutt_Gurjar]

Please try in slice filters

Gerhard_Viljoen:

I am uploading employee contracts and have the date of each contract that was signed in a field. I want to do a slice where only the latest field of each unique employee is shown as each year their contracts are updated.

[Key Column]= MAXROW(“Table Name”, “Contract Upload Date Column”, [Employee Name]=[_THISROW].[Employee Name])

Gerhard_Viljoen:

And then I only want to show the 10 employees whose contracts were signed the longest time ago. I want to show this in a graph or table view on a dashboard.

IN( [Key Column], TOP( ORDERBY(Table Name[Key Column], [Contract Upload Date], FALSE), 10))

help.appsheet.com

MAXROW()

Row with greatest value in column

help.appsheet.com

ORDERBY()

Sort row references

help.appsheet.com

TOP()

Initial list items

[Gerhard_Viljoen]

Perfect! Thanks Suvrutt.

The first expression works. Where do I enter the second expression?:
IN( [Key Column], TOP( ORDERBY(Table Name[Key Column], [Contract Upload Date], FALSE)` , 10))

[Suvrutt_Gurjar]

The second expression is for the another slice filter for finding 10 employees with oldest contract dates.

[Gerhard_Viljoen]

Okay. Thank you very much for your assistance.