How to perform calculations in KIbana 6.5?

[Sonam_Verma]

I want to calculate the following:
Vol(%) - (Total Volunary attrition till the month/avg HC)*(365/No. of days in the year so far)

I am new to kibana and want to know the ways to calculate above.
The fields on the right hand side also needs to be calculated.

Thanks in Advance!

[mattkime (Matthew Kime)]

Hello Sonam_Verma

Have you considered using a scripted field? https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-script-fields.html

[Sonam_Verma]

Yes.. I did after going through painless scripted fields. But complexity increases as scripted fields consider single document.

[mattkime (Matthew Kime)]

Which Kibana feature are you using? Maybe there's a feature specific way to solve this.

But complexity increases as scripted fields consider single document.

Could you say more about the problems you're having with calculated fields?

[Sonam_Verma]

I am using Kibana 6.7 Visual builder feature. I want to calculate percentage of Voluntary Attrition of a company- so for this, I have 2 CSV files. One is having data of active employees and other is having data of Attrition.

Now, I pushed merged data from both sheets to ES using logstash. Therefore, finally I have an index which is having merged data of active employees and attrition.

My calculation requires to calculate following-

1. Total count of Voluntary Attrition
2. Average Headcount of company

Now, after calculating them, I need to show the result on visualization. But the problem is, that they need to be calculated as different series in Metric visual builder, then only they are generating desired results. So, Can you help me with this?