I have created an attendance details table that captures the attendance for an employee checking in and checking out every day. I need to display the sum total of today’s employees count on a screen that helps the operations manager manage stuff.
In order to get this number, I have created an IF Else type of field that checks if Check In Time
is within today and then outputs 1 else it outputs 0. I then aggregate this column into another field and display the same.
The issue is that the number continues to display the total count, even after the employees check out. Hence this calls for checking
`If (Check-in time is within today AND check-out time is empty) show 1 else show 0. This sum would represent the total truth. I am unable to use multiple conditions in IF as per the current design.
I can brute force this by creating two columns separately checking the two conditions and then creating a third column that resolves based on the first two. But my application is already slow and I DO NOT want to load it further by adding multiple columns. Also, this is a generic use-case that might be used in various scenarios.
Can someone help?