topic Employee present or absent? in App Development

Employee present or absent?

Karahs — Thu, 02 Jun 2016 07:49:54 GMT

Hello everyone,

My question is that i have data with months and their employee Id, i want to find the diffrence between the employee id with respect to months.

Eg. some of the employee Id is present in Jan and some of the employee Id are not there in Feb that means they have left the company,how will i come to know which employee left in that month?

Thanks!!

Re: Employee present or absent?

swuehl — Thu, 02 Jun 2016 08:22:14 GMT

There are different approaches:

a) just make selections in month to see the existing and not existing id, or in an id to see the month with an relation

b) have a look at something like

New/Lost/Returning/Loyal Customers

Intervalmatch Count Open Items

Re: Employee present or absent?

Ralf-Narfeldt — Thu, 02 Jun 2016 08:28:41 GMT

Emp:

Load *, MakeDate(Year,Month) As MonthDate;

Load * inline [

Employee,Year,Month

A,2016,1

B,2016,1

A,2016,2

B,2016,2

A,2016,3

A,2016,4

];

LastMonthWorked:

Load *, Year(FinalDate) &'-'&Month(FinalDate) As FinalMonth;

Load

Employee, Max(MonthDate) As FinalDate

Resident Emp Group By Employee;

Result of LastMonthWorked is:
A 2016-Apr

B 2016-Feb