Group Active Employees based on tenure

Hi Ashish,

the 2,0,1 are the count of employees as of date with tenure months 1,2,3 respectively. 

A got terminated on 7th so as of 8 he is not active employee. He is not conisdered. 

B has tenure of 1 month as of 8th  

C has trnure of 3 months as of 8th

D has tenure of 1month as of 8th date. 

hence the table shows the result of 2 employees with 1 month tenure. 1 employee with 3 month tenure

if 8th date log is not there for a employee, we need to get the max date which is less than as of date to get the latest log of that employee. 

hope this explains. Kindly let me know if you need further explanation.  

thanks for your reply.