Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Dear Tresesco,
This is Exactly the Result what i want but .... when i add this listbox in my dashboard attached in this post it is not working as same as the sample data.
This attachement shows the tran_date and a table with EmpId filter as few are not associated with that date, this people not associated to this selection list should be displayed As you shown me
Could you kindly Help me by looking into the dashboard attached in the first post
Regards,
Sai.
This?
=Aggr(If(len(Concat(trim(tran_date)))=0,EmpName), EmpName)
If you prefer set analysis:
=Aggr(Only({<EmpName={"=len(Concat(trim(tran_date)))=0"}>}EmpName), EmpName)
No Tresesco ... On a particular day it should display the names.
lets say on 2nd of nov some 'N' people they are not in office now these people names to be displayed as Absent
On dynamically selecting the date filter no list of names it is displaying.
May be combining these two expressions with an if like:
=If( GetSelectedCount(tran_date), Aggr(Only({1<EmpName=E(EmpName)>}EmpName), EmpName),
Aggr(If(len(Concat(trim(tran_date)))=0,EmpName), EmpName)
)
Hi Tresesco ... Thank you for spending your valuable time for helping me.
Requested My HR department for list of people to tally the output, so will update you once i receive the list.
Regards,
Sai.
Hi Tresesco,
this expression is displayed in list box but the same in a table is no showing the data
Requirement is list of people absent as on or max date with out any selection.
=If( GetSelectedCount(tran_date), Aggr(Only({1<EmpName=E(EmpName)>}EmpName), EmpName),
Aggr(If(len(Concat(trim(tran_date)))=0,EmpName), EmpName)
)
In a table? How would that look like? Could you create a table and share and explain the expected output?
Actually this is a biometric data associated with employee masters.
Now show the list of absent people like
Empid | EmpName | last sign In date
Here we want to ignore people who are not active from a month i.e no entries signin and signout people should not consider in absentees list.
PFA.
So, you want a list of empnames who were not present on max date and were present in at least one day in last 30 days. Is my understanding correct?
List of absent people should be able to show on selection of date if no date got selected this should show today's list of people by default.