Question ajoutée par
SIVADASAN PANTHEERADI
, Sr ADMN ( Actively looking for a NEW JOB) , DYNCORP INTERNATIONAL LLC (US COMPANY)
Date de publication: 2013/08/28
First of all, know what dataset you want.
For example: name, department, function, entry date, leave date.
Then you create a list out of your HR system with above data and put it in an Excel table.
How you present your analysis completely depends on the required reporting style. Do you need only gross totals, or also per department or function?
I give an example on gross totals:
You can create a Pie Chart with only4 figures and use criteria fields to select the numbers of employees that came in, stayed or left the business. I prefer to use the DCOUNTA formula to do the selection. An example for2012:
1. incoming (criteria: entry date >=01/01/2012 and <=31/12/2012 and leave date = empty)
2. leaving (criteria: leave date >=01/01/2012 and <=31/12/2012 and entry date <01/01/2012)
3. passing by: (criteria: entry date >=01/01/2012 and leave date <=31/12/2012)
4. staying (criteria: entry date <01/01/2012 and leave date = empty or leave date >31/12/2012)
Of course you can add extra criteria to your formulas, like department or function.
Please note that with above criteria I avoided people to be counted2 times, as well as in 'incoming' as in 'leaving'.
The formula looks a bit like this: =DCOUNTA(A:E,A1,AA1:AB2)
Where:
A:E = table with employee data
A1 = the field (name) you are couning
AA1:AB2 = the criteria you are using
I hope this helps.....
par
Ali Safer , Business Central Technical Consultant , Microsoft gold partner
Hi,
You can use Power Pivot Table and Chart.
PowerPivot is a recent tools and very powerful one for this cases.
Also, For adnvanced uers you can try Analysis Servcies.
Regards;