Attendance Records

[XXX_Rosy_XXX]

I need help to get started I have a csv file with columns names ID, Name, Department, Time, Attendance Status and lastly Attendance Check Point.

Here a few things I need

1.Create a Date Column

2. Create Time In and Time Out Columns

        there maybe double record of staff who check in or check out, i just need to take the earliest timing for check in and latest timing for check out.\

• Take the earliest time as Time In.

• Take the latest time as Time Out.

3. Handle Missing Check-In/Check-Out

• if only one record exists (e.g., just a check-in or check-out), mark the missing side.

• Add new columns: Missed Check In and Missed Check Out.

Lastly I need another sheet

For each date, I would like to know:

1. No. of staff present with BOTH check-in & check-out

2. No. of staff with missing check-in

3. No. of staff with missing check-out

How do I started with Alteryx, please guide me 

[Yoshiro_Fujimori]

This may make a good Weekly Challenge problem, as there would be multiple solutions😀

Person ID	Name	Department	Date	Attendance Check Point	Time In	Time Out	Missed Check In	Missed Check Out	Both present
11	Pearlie	Sales	2025-08-01	Door1	2025-08-01 07:57:00	2025-08-01 17:32:00	0	0	1
11	Pearlie	Sales	2025-08-04	Door1	2025-08-04 07:55:00	2025-08-04 18:04:00	0	0	1
11	Pearlie	Sales	2025-08-05	Door1	2025-08-05 07:38:00	2025-08-05 18:02:00	0	0	1

Date	Sum_Missed Check In	Sum_Missed Check Out	Sum_Both present
2025/8/1	0	0	1
2025/8/4	0	0	1
2025/8/5	0	0	1