Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all,
i'm building the HR dashboard in that i need to calculate the headcount of the employee can anyone plz help me regarding this one
basically i'm struck in script part don't know where to start plz help me
i got tables like employees,internal candidate,external candidate,gender,employeetype etc
overall tables 20
i need to count the employe statistics,headcount so on
Try something like:
=count(distinct employeeID)
For Headcount...Employee details are required.
Use Employee ID or may be Staff ID to get Head Count.
Total HeadCount : Count(Distinct EmployeeID) //this will give you total headcount
yea i tried that one ,but the data is in the hirearchy
Can you post your qvw here?
Firstly, need to know the logic of getting Headcount. Secondly need to know the table mappings.
Hi Naresh,
I think if you did this front end (i.e. not in script) a formula along the lines of…
=Count(DISTINCT [EmployeeIdField])
would give you headcount.
Regards,
Jason.
can anyone tell me how to calculate the staffing rate and tenure
These are most likely operational definitions within your organization. For example at my company we have groups, like new employees(<1 year),1-5 years, 5-10...etc.
I am not sure what staffing rate means and I don't know what data you are working with.
Hi DataGrrl,
thanks for the reply im just working on normal data which consists of employee details and designations,project assignments,employee type,internal candidate,external candidate,gender,businessunits buket config etc