Hi there !
I have to create dashboard for human resources department. I have to calculate the turn over for a period.
Turn Over calculation is : the sum of people who have left the company during Year Y / sum of active user in the system on Year Y
My index contains all info i need :
End of contract Date (2 contracts ended during year 2018)
User status: active or inactive (18 active on 21/12/2018)
Turnover = 2/18 = 11%
Is it possible to calculate that kind of thin in kibana ?
Thank You so Much !!!