employees attendance behavior

abeeralharbi — Fri, 02 Apr 2021 08:02:30 GMT

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.

Re: employees attendance behavior

Vegar — Mon, 29 Jul 2019 22:16:44 GMT

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 ;

Re: employees attendance behavior

abeeralharbi — Mon, 29 Jul 2019 22:50:01 GMT

thank you i will try it. but how about calculating absents and late comers and early leaves.

topic employees attendance behavior in App Development

employees attendance behavior

Re: employees attendance behavior

Re: employees attendance behavior