Doing Complex Calculations in Kibana

[Pulkit_Sachdeva_US (Pulkit Sachdeva)]

Hi,

I have data from a survey coming into elastic search. I want to do visualizations for customer satisfaction, net promoter scores, etc. The issue I am facing are in calculation for these results.
I am not able to include multiple fields in my calculation for these scores.

E.g.,

I have attached a sample record.

Now, the error on customer satisfaction score on records like these is calculated as
1.96 * POWER(cust_sat*(1-cust_sat)/count(*),0.5):

cust_sat = sum(case when answer in ('4','5') then 1 end)/count(*)

I am new to Kibana and cant seem to find a way to do this in Kibana.

An additional requirement is any filter I do on Kibana should result in this error number changing according to the filtered data.

Looking forward to getting helpful answers.

Thanks,
Pulkit

[warkolm (Mark Walkom)]

You will need to use a scripted field to do this with the data already in ES - https://www.elastic.co/guide/en/kibana/5.4/scripted-fields.html

However you should consider doing this before you send it to ES, ie during the index process.