Format Sum aggregation results in Kibana

Hello!

I'm getting huge numbers as result in SUM aggregations in Kibana, for example, in a SUM aggregation that the result wold be 0, in kibana visualization (data table visualization) i'm getting the number 2.3283064365386963E-10, that is 0.00000000023283064365.
I have already formated the number field at the index pattern to 0.0,[00], but the result in SUM aggregations seems to not respect this format.

May you guys know if we can fromat the SUM aggregations format to 2 decimal places?

Steps to reproduce:

PUT teste_indice_sum
{
  "settings": {
    "number_of_shards": 1
  }, 
  "mappings" : {
  "properties" : {
  "teste.calc" : { "type" : "scaled_float", "scaling_factor": 100 }
}
}
}

PUT teste_indice_sum/_doc/1
{
  "teste.calc": 0
}

PUT teste_indice_sum/_doc/2
{
  "teste.calc": 18382.26
}

PUT teste_indice_sum/_doc/3
{
  "teste.calc": -808560.25
}

PUT teste_indice_sum/_doc/4
{
  "teste.calc": 131606.72
}

PUT teste_indice_sum/_doc/5
{
  "teste.calc": 5576474.22
}

PUT teste_indice_sum/_doc/6
{
  "teste.calc": -110617.43
}

PUT teste_indice_sum/_doc/7
{
  "teste.calc": 14002.85
}

PUT teste_indice_sum/_doc/8
{
  "teste.calc": -136577.68
}

PUT teste_indice_sum/_doc/9
{
  "teste.calc": 104506.85
}

PUT teste_indice_sum/_doc/10
{
  "teste.calc": -4357917.55
}

PUT teste_indice_sum/_doc/11
{
  "teste.calc": -431299.99
}

PUT teste_indice_sum/_doc/12
{
  "teste.calc": 0
}

Thanks in advance!

What version of Kibana are you using? I think this has been fixed a couple of versions ago.
LE: yeah, for me on 7.5.0 using an average agg i can get it to display with 1 decimal of precision instead of 3.

Hello Marius!

Thanks for replying!

I'm using Kibana 7.0.1. On your test on 7.5.0, did you get the values on scientific notation too? (i.e. 2.3283064365386963E-10). Because on 7.0.1 i cannot format the aggregation result to 2 decimal places.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.