How to calculate a turnover

[#1]

Hi Everyone,

I have a table like below and I want to calculate the turnover of ACTORID per period. (ACTORID is the name of the employees)

So I want to do a bar chart with month in dimension for exemple and the turnover in the expression.

Could any one  help me please? Thanks you.

ACTORID	Period
BBT	40909
BBT	40940
BBT	40969
BMS	40909
BMS	40940
BMS	40969
BPI	40909
BPI	40940
BPI	40969
BSK	40909
BSK	40940
BSK	40969
CAN	40909
CAN	40940
CAN	40969
CCN	40909
CCN	40940
CCN	40969
CDR	40969
DCE	40909
DCE	40940
DCE	40969
DCS	40909
DCS	40940
DCS	40969
FVS	40940
HES	40940
HSN	40909
HSN	40940
HSN	40969
IJS	40909
IJS	40940
IJS	40969
ISS	40909
ISS	40940
ISS	40969
KRS	40909
KRS	40940
KRS	40969
KWS	40909
KWS	40940
KWS	40969
LLS	40909
LLS	40940
LLS	40969
MLT	40909
MLT	40940
MLT	40969
MSN	40940
MSN	40969
NSN	40909
NSN	40940
NSN	40969

[its_anandrjs]

Hi,

In load script make change like

LOAD

ACTORID,   

Period,

Month(Date(Period)) as Month,

Date(Period) as Date

From Source;

Regards

Anand

[#3]

Hi Ben,

have a look at the attached, should give you an idea of how to do this

hope that helps

Joe

[#4]

Ok thank you for theses ansewers but i look for the formula of turnover. I have only these datas and i want to know when how much employees get in and how much get out.

[#5]

you only have those two fields? You'll need some fact data in order to calculate anything (in my example I added a value field for instance).

[#6]

Yes I have only those two fields. The period is a date when the ACTORID have worked. So With these date i want to deduct the time when he came in the company and when he left and count them, to calculate the turnover.

[#7]

Not sure I follow what you are trying to calculate, this is staff turnover you are looking for? How would you determine when an employee joined and left?

[consenit · Accepted solution]

Hi there.

Assuming that for each employee the minimum date is the date joined, and the maximum date is the date left, you can use calculated dimensions:

=DATE(AGGR(MIN(Period), ACTORID))

and:

=DATE(AGGR(MAX(Period), ACTORID))

See example attached.

Kind regards,

Ernesto.