Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i was given this dataset which represent a daily fingerprint for X company employees, each row is represent a scan of finger while the ID is represent the employee itself. I was expected to give us some insight about employees attendance and behavior (absentees last 7 days , late comers, accents, presents, number of employees ...etc)
The problem is that there is no flag in the dataset that tells me when was the check in and the check out and some time like the case mentioned below there was mutable records at the same day for the same employee. So I think the only way to do it is to take the first reading for same ID and same day and flag it as check in and take the last and flag it as check out. but i don't know how to do it in qlik sense.
You can do this to solve it
LOAD
ID,
Date,
Min(Time) sa [check in],
Max(Time) sa [check out]
From FingerprintExcel
Group by ID, Date ;
You can do this to solve it
LOAD
ID,
Date,
Min(Time) sa [check in],
Max(Time) sa [check out]
From FingerprintExcel
Group by ID, Date ;
thank you i will try it. but how about calculating absents and late comers and early leaves.