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
Did you check the new thread?
Hi Jose,
I want to develop view as per attached can you please help to achieve the same ?
Vikas
Hello Vikas,
What exactly do you need? You almost got it and the error you are reporting is fixed in the second sheet.
error is not related to user response it is related to Jonathan I think solution is given by him is workable
for me.
What I want is Community%20Attrition%20v002.qvw
Can you give guide lines how to achieve the same.
Vikas
CHECKED AND FOUND IT IS CORRECT ANSWER.
Many Thanks
Vikas
Hi
I have the same requirement . showing opening and closing employee headcount into my application on month on month basis . also show the waterfall chart on current month and yearly . but in my application am not able to use loops as records are in millions and we are using master calendar . can someone tell me how can I achieve this
Hi All
In one of the requirement I have to show opening and closing emp headcount on month on month basis in my dashboard . also I have to develop the water fall chart to show the current Month and current year opening and closing Emp headcount with hiring and leaving of that month . am using master calendar and on selection of that the chart will filter out accordingly . formula to calculate the opening and closing are given below
Opening balance = closing of the last month
Hiring = Current month joining
Leaving = Current month Leaving
Closing - Opening + Joining -leaving
can someone help me to achieve this requirement
Month | Opening Balance | Hiring | Leaving | Closing |
Apr-17 | 1234 | 10 | 5 | 1239 |
May-17 | 1239 | 5 | 4 | 1240 |
Jun-17 | 1240 | 20 | 10 | 1250 |
Jul-17 | 1250 | 25 | 4 | 1271 |
Aug-17 | 1271 | 20 | 10 | 1281 |
Sep-17 | 1281 | 10 | 10 | 1281 |
Oct-17 | 1281 | 40 | 20 | 1301 |
Nov-17 | 1301 | 10 | 5 | 1306 |
Dec-17 | 1306 | 25 | 8 | 1323 |
Jan-18 | 1323 | 32 | 12 | 1343 |
Feb-18 | 1343 | 12 | 6 | 1349 |
Mar-18 | 1349 | 28 | 20 | 1357 |
Apr-18 | 1357 | 5 | 20 | 1342 |
May-18 | 1342 | 9 | 5 | 1346 |
Jun-18 | 1346 | 0 | 0 | 1346 |