Is there a way I can calculate and display NPS in Kibana?
I can see that I can add scripted fields that allow me to manipulate the value from a single document field, but is there a way to display the result of a calculation based on the results from multiple queries? I have a feeling that this can only be done by building a Kibana plugin?
For example, if I have a field (call it score) can I calculate a result based on all scores from 3 queries:
Query 1 - Count all scores in date range
Query 2 - Count all scores > 8 in date range
Query 3 - Count all scores < 7 in date range
Display result of:
(query 2 * 100 / query 1) - (query 3 * 100 / query 1)
If this does require a plugin then let me know if you're available to write one for me!