list of Names having no entries

[kakani87]

Hi Folks ....

I want to display the records where there will not be entries

i.e. list of people Absent in a day using biometric access data with  flag 0,1 (IN,OUT)

here I'm Attaching a sample

Can any one help me to acheive this

Regards,

Sai.

[kakani87]

Yes absolutely

[kakani87]

Hi Tresesco ... Any solution for this issue

[tresesco]

I will try to spend sometime on it today and let know accordingly.

[kakani87]

Okay.

[tresesco · Accepted solution]

May be like this?

=Max({<tran_date,EmpName=p({<tran_date={'>$(=num(Addmonths(today(),-1))) <$(=num(Today()))'}>})>* <tran_date,EmpName=e({<tran_date={'$(=If(getselectedcount(tran_date),Max(tran_date),today()))'}>})>}tran_date)

When you clear all and see, you might not see any employees, because you don't have data for Dec'17 data (today()- 1 month). You can replace highlighted -1 by -2 to see results for absentees who were at least present in last two months, or try on data where you have data of last months.

[kakani87]

Hi Tresesco,

How to display only the EmpNames with last login lesser than the maximum date.

Lets say with out dynamic selection only the people last logged in date less than max date to be displayed to consider them as on date absent.

Here in the above it is displayed the people who logged in  on max date as well showing with out filter in tran_date.

[kakani87]

Hi  Tresesco ... can we display all days of an employee in a month where is not in

lets say for example an employee list of days absent to be displayed this way

EID              Emname   Dates(Absent in the month)      

C000872      Ajith            16-12-2017

C000872      Ajith            20-12-2017

C000872      Ajith            31-12-2017

now he is considered as all three days absent.

if we filter month wise like this