Null values appear in line chart with value 0.00

(ilanas) #1

Good morning,
I have a doubt, i have an index with a lot of values of a field with null values in search. When i plot this field in line chart of kibana this all values appears with the 0.00 value. Why catch the value 0.00 if really is null or -? How can i delete this value from the chart if in the same register there are 2 diferent fields that i plot too and they are'mt null?

(Larry Gregory) #2

Can you share more details on your data, and show how your chart is configured? I threw together a quick line chart using an index with null values, and it rendered properly without any dips to 0:

(ilanas) #3

in the discover i have for example this values with null an other with number

in the table bisualization all the null values appear as 0


this is the line chart configuration:

in the same chart y want to plot the 3 metric sum but not if they have null value.

(ilanas) #4

do you understand now?

(Larry Gregory) #5

I think so; you're trying to avoid these dips:

If you were to omit the null values, what would you expect to see in its place?
You could set the "missing" property on your sum metrics to provide a fixed value if it's missing:

(ilanas) #6

If is null value i don't want this line appear in the right and in the graph. only the values not null values. if is null value never it has a value so i don't want this line in thje chart

(system) closed #7

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