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-
- Total count of Voluntary Attrition
- 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?