I’ve been trying to play around with an expression for a slice that will allow me to show all the employees that have not had a visitation record created for them in the last 4 weeks.
I’ve come up with things like the following:
IF(TODAY() > (MAXROW(“Trainee Records”, “Date”)+28),TRUE, FALSE)
MAXROW(“Trainee Records”, “Date”, (IF(TODAY() > ([DATE] + 28)),YES,NO))
None of them have really worked
The main part of my data is the one worksheet (EmployeeRecords) where I have all the visitation records recorded with headings such as ,[Date], [Site], [Employee Name], [Work Overview]. I would have multiple records for the same employee at different dates (i.e. as such RowNumber has become my key).
I would like to be able to have a slice (and then subsequent format rules to make it pretty) that looks at the latest date/visit per Employee in the EmployeeRecords table, then see if that date is more than X days ago (e.g. 4 weeks). If the latest date is more than 4 weeks ago, I want it in the slice. I do not want the slice to show records where the date is more than 4 weeks ago BUT it is not the latest date for any given employee.
I appreciate any advise.