Problem with numbers


(Fred) #1

Hello, I have a problem when I import data.

I have Kibana 5.6.3.
in Management -> index patterns -> this field is correctl defined as a number with default format (i have also tested with a specific format 0,0.[000]

In my CSV file, I have a column with integer sums (5, 10, 20), and with decimals (5.99, 9.99, ...).

The problem is that Kibana does not show decimals, I just have 5, 10, 20, 9, ...
The mapping is set to "integer". Does the CSV have to have a particular format for the numbers ?

                        "Amount":{
                          "type":"integer","index":"not_analyzed"
                          },  

Thank you !


(Fred) #2

From Discover it's ok.

But From Visualize there is no decimal.

I dont understand why.


(Tim Sullivan) #3

The field in the Elasticsearch mapping can only have 1 data type, so if you want to be able to work with decimals, the mapping should be one of the types that have higher precision than integer such as double, float, half_float, etc: https://www.elastic.co/guide/en/elasticsearch/reference/5.6/number.html

The data in Discover shows the value from _source which is the original data that the document was indexed with. But the table visualization is an aggregation that shows the value as it is mapped.


(Fred) #4

Awsome ! It works !
Thanks !


(system) #5

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