head count

[nareshthavidishetty]

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

[nigel987]

Try something like:

=count(distinct employeeID)

[Anonymous]

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

[nareshthavidishetty]

yea i  tried that one ,but the data is in the hirearchy

[nigel987]

Can you post your qvw here?

[Kushal_Chawda]

Firstly, need to know the logic of getting Headcount. Secondly need to know the table mappings.

[#7]

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.

[nareshthavidishetty]

can anyone tell me how to calculate the staffing rate and tenure

[datagrrl]

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.

[nareshthavidishetty]

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