I'm trying to use the total function in a Kibana visualization and I have a table with 2 columns, one is a string and the other one is a Unique Count of some strings. The values seems correct, but when I try to apply the Total function on those values, nothing happens for any operation (SUM, MIN, MAX, AVG). The only operation that the total function shows is COUNT.
If I change the metric to Unique Count and the filed type a number, the SUM function works. Is there a limitation for the Total Function? Is the result of Unique count still a string ? Is there a way to convert it to number?
Kibana Version: 5.5.2
Note: Was this something that worked on Kibana Version 5.0.0 ?