Line visualization

[hiba (chaieb)]

Hi ,
I use kibana 7.7.0 how can i dislay values in a line visualization.
for example :
axe X : date (i can display it )
axe Y : price ( I want to display the prices of each document as in discover , without any function like avg or sum or max ......)

any help please !

[Petr.Simik]

I think axe X is a bucket by default auto scale. It creates buckets per 5minutes for instance.
on axe Y are values within this 5min bucket.
So you have to choose what value within 5min interval you want to interpret.
You can have multiple lines (min, avg, max) so you will have the whole picture.

[hiba (chaieb)]

thanks for reply,

i don't want to use min ,max or avg ...
i juste want a simple display of the value without any function or aggregation in the axe Y

[Petr.Simik]

What value do you want to show on axe Y if within actual time bucket you have more than 1 value.
this is why avg/max/min is the choice.
If you use all three and choose buckets minimum interval to the granularity of your dataset , all 3 max/min/avg will have the same value so in this case you will have you graph.
however in case of many records Kibana automatically scales up the interval .. To see all values you shoud zoom-in.

in time series data you have allways data (per interval) so you have to do some aggregation within this interval.

[hiba (chaieb)]

Hi,

this is my data:

{
"took" : 0,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 4,
"relation" : "eq"
},
"max_score" : 1.0,
"hits" : [
{
"_index" : "global-status",
"_type" : "_doc",
"_id" : "G6sF3XMB1AjoIOBx-GAQ",
"_score" : 1.0,
"_source" : {
"date" : "2020-01-01",
"friendly" : 381531.332,
"travel agency" : 150140.536,
"dealer" : 74101.27,
"corporate" : 756.0,
"N/C" : 9688.85,
"local agency" : 48005.145,
"B2B" : 612450.188,
"B2C" : 51772.945
}
},
{
"_index" : "global-status",
"_type" : "_doc",
"_id" : "JqsG3XMB1AjoIOBxB2DZ",
"_score" : 1.0,
"_source" : {
"date" : "2020-02-01",
"friendly" : 322148.332,
"travel agency" : 458769.536,
"dealer" : 85476.27,
"corporate" : 962.0,
"N/C" : 9222.85,
"local agency" : 75612.145,
"B2B" : 768425.188,
"B2C" : 51478.945
}
},
{
"_index" : "global-status",
"_type" : "_doc",
"_id" : "MasG3XMB1AjoIOBxFmC-",
"_score" : 1.0,
"_source" : {
"date" : "2020-03-01",
"friendly" : 896547.258,
"travel agency" : 200140.694,
"dealer" : 84796.166,
"corporate" : 590.147,
"N/C" : 6984.423,
"local agency" : 95762.184,
"B2B" : 7895126.3,
"B2C" : 32548.433
}
},
{
"_index" : "global-status",
"_type" : "_doc",
"_id" : "PasG3XMB1AjoIOBxQWBl",
"_score" : 1.0,
"_source" : {
"date" : "2020-04-01",
"friendly" : 6958472.125,
"travel agency" : 458632.142,
"dealer" : 147236,
"corporate" : 147859.0,
"N/C" : 10000.125,
"local agency" : 22158.147,
"B2B" : 814256.357,
"B2C" : 695123.143
}
}
]
}
}

i want to display in:

• axe X "date" per month
  -axe Y the value of "B2B","travel agency","B2C", "corporate" .

[hiba (chaieb)]