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!
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))
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))
The second expression is for the another slice filter for finding 10 employees with oldest contract dates.
Okay. Thank you very much for your assistance.