# HR metrics : tur over, divide 2 sum
**URL:** https://discuss.elastic.co/t/hr-metrics-tur-over-divide-2-sum/167592
**Category:** Kibana
**Created:** [February 8, 2019, 8:53am UTC](https://discuss.elastic.co/t/hr-metrics-tur-over-divide-2-sum/167592 "2019-02-08T08:53:06Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@crigastel](https://discuss.elastic.co/u/crigastel)
#### Post date: [February 8, 2019, 8:53am UTC](https://discuss.elastic.co/t/hr-metrics-tur-over-divide-2-sum/167592/1 "2019-02-08T08:53:06Z")
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 :
User id
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 !!!
---
### Author:  [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)
#### Post date: [February 8, 2019, 10:25pm UTC](https://discuss.elastic.co/t/hr-metrics-tur-over-divide-2-sum/167592/2 "2019-02-08T22:25:13Z")
Hi there, you should be able to do this using the "Time Series Visual Builder" visualization type, in the Visualize app. Please refer to the steps in [Doing Math over count of events](https://discuss.elastic.co/t/doing-math-over-count-of-events/97278). In step #3, you'd use the field you're using to determine "End of contract date" as the numerator, and the field you're using to determine "User status" as the denominator. Hope this helps!
CJ
---
### Author:  [@crigastel](https://discuss.elastic.co/u/crigastel)
#### Post date: [February 12, 2019, 9:17am UTC](https://discuss.elastic.co/t/hr-metrics-tur-over-divide-2-sum/167592/3 "2019-02-12T09:17:28Z")
Thanks for your answer ! As i'm not technical i don't undestand : i will ask to my dev ^^
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 12, 2019, 9:17am UTC](https://discuss.elastic.co/t/hr-metrics-tur-over-divide-2-sum/167592/4 "2019-03-12T09:17:32Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.