Time series spot line with specific value

[MLaure19 (Aix)]

Dear all,

I am struggling a lot to represent a simple time-series graph with Kibana.
I don’t want my data to be aggregated.

I basically just would like to plot my carbon monoxide concentrations on a time-series graph.

• Y-axis : carbon monoxide concentrations
• X-axis : dates (hours)

My index looks like this:

    "dates": [
  "2020-02-26T14:00:00+00:00",
  "2020-02-26T15:00:00+00:00",
  "2020-02-26T16:00:00+00:00",
  "2020-02-26T17:00:00+00:00", 
],
"pollutants": {
  "CO": {
    "description": "Carbon monoxide",
    "concentration": {
      "mugm3": {
        "values": [
          232.3519125804305,
          235.12185376733538,
          241.92035404741765,
          248.6359430372715,

Do you know how to create such a visualization ?

Thank you very much for you help !

Best regards,

Marie-Laure

[flash1293 (Joe Reuter)]

Can you elaborate on that? Is the JSON you are showing here a single document and there will be multiple ones like this (one per day or something like this)?

[MLaure19 (Aix)]

Hi Flash,

Many thanks for your reply. So basically I am ingesting 24h pollution data, meaning one concentration value per hour, so 24 values in total. My goal would be to place those values on a graph (Y-axis) and place the 24 hours on the X-axis in order to see how pollution is evolving during the day.

Please find a printscreen attached. I don't know if this can help you.

Thanks again.

[flash1293 (Joe Reuter)]

Thanks for you answer.

In this form the data is very hard to visualize in Kibana. Consider changing the shape of your documents to one document per measurement.

{ dates: 'Feb 26, 2020 @ 14:00:00.000', coConcentration: 232.352 }
{ dates: 'Feb 26, 2020 @ 15:00:00.000', coConcentration: 231.92 }

and so on.

With the two separate arrays Kibana can't infer the association between date and value.

You can do this for example with Logstash and the split plugin: https://www.elastic.co/guide/en/logstash/current/plugins-filters-split.html

With the separate document per measurement datastructure you can visualize them using the regular line chart by using a date histogram and the x axis an average of co concentration on the y axis.

[MLaure19 (Aix)]

Hi Joe,

This helps tremendously, many thanks !
I am not using Logstash (it does not work on my computer) but I am going to try to split by using my Python program.

Let's see...