I have many documents with a floating field ("duration") representing the response time of a HTTP request in seconds. Its value is always smaller than one (example: 0.018). I want to visualize the average response times in kibana.
I am able to create a new visualization with the average value of the "duration" field. The problem is that it is always rounded to 0. I've also tried creating a scripted field using doc['duration'].value * 1000.0, but the value of the scripted field is also zero.
How could I calculate the average or, in general, work with small floating values in Kibana?