Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have empno , empname, doj,date_of_resign fields
how i can show opening headcount/gross additions/attrition/closing head count
GRADE | Opening Headcount | Gross Additions | Attrition | Net Additions | Closing Headcount |
ASSOCIATE | 193 | 3 | 0 | 3 | 196 |
STAFF | 74 | 3 | 0 | 3 | 77 |
SUPERVISOR | 80 | 0 | 0 | 0 | 80 |
TRAINEE | 32 | 1 | 1 | 0 | 32 |
WORKERS | 95 | 0 | 0 | 0 | 95 |
Total | 474 | 7 | 1 | 6 | 480 |
Please any one have idea please give guide lines also I want to calculate Attriation rate company level how I do this ?
Thanks in avanace
Vikas
I really appreciate your help Thanks.
Jose I really require when user select 2013-14 then closing head count of employee should match with Apr-2014-15
987 will be opening how to do this please give any idea ?
Vikas
hello
Can you please explain me how Tdata and Employee tables will be join which is common key ?
// Join the tables
Join (T_Data)
LOAD * Resident Employees;
Vikas
I have attached emp.xls can you please create qvw and send me
Thanks
Hello Vikas,
I see no attached file - however I cannot understand your requirements. CAn you please explain them a little bit more?
Regards.
Hii
Please see I have open new threat Head Count Analysis - Employee ( Opn + Gross Addtions -Resignations = Closing)
Requirement is when user select Year/Month/Qtr following chart should display, Suppose when user will select
Mar-2014 head count will be 480 , When user will select Apr-2014 so 480 will be in opening head count like this I want to display in chart
GRADE | Opening Headcount | Gross Additions | Attrition | Net Additions | Closing Headcount |
ASSOCIATE | 193 | 3 | 0 | 3 | 196 |
STAFF | 74 | 3 | 0 | 3 | 77 |
SUPERVISOR | 80 | 0 | 0 | 0 | 80 |
TRAINEE | 32 | 1 | 1 | 0 | 32 |
WORKERS | 95 | 0 | 0 | 0 | 95 |
Total | 474 | 7 | 1 | 6 | 480 |
I have attached Emp excel file
Please can you create qvw n send me.
Thanks
Vikas
Mr.Jose
Following is requirement.
User Will SElect Year/Qtr/Month
DOJ -> Date of joins and DOL -> Date of Leaving and S_Active -> Active/In-Active fields to be considered to calculate this head count.
Let me know If you know more information.
Thank u very much.
Vikas
Hi,
I have answered in the new thread.
Mr.Jonathan Can you give full script Please help me
Vikas
I think this script will resolve my issue please help me to get desired result.
Vikas
//Load employee data
Employees:
LOAD grade,
empno,
empname,
MonthStart(doj) As StartDate,
MonthStart(date_of_resign) As EndDate
From .....
// Join the tables
Join (T_Data)
LOAD * Resident Employees;
1. From.... ??????????
2. Join which condition ?????
Vikas